MySQL LIKE Operator & Wildcards Tutorial in Hindi / Urdu

Поделиться
HTML-код
  • Опубликовано: 2 окт 2024
  • In this tutorial you will learn mysql like operator tutorial in Hindi, Urdu.You can learn how to use like operator with wildcards in SELECT command in mysql hindi.
    PHP Tutorial in Hindi Playlist
    • ✅ PHP Tutorial in Hind...
    MySQL Tutorial in Hindi / Urdu Playlist
    • 🥇 MySQL Tutorial for B...
    Official Website
    www.yahoobaba.net/
    Follow us on Facebook
    / yahooobaba
    Follow us on Twitter
    / yahooobaba
    #mysql #webdevelopment #php

Комментарии • 127

  • @shubhamkumarsingh8818
    @shubhamkumarsingh8818 11 месяцев назад +10

    3 saal hogye inn lectures ko youtube pe. aur aajtak itna achaa kisi ne nai padhya.
    sir hatsoff to your hardwork. and thank you very much.

    • @YahooBaba
      @YahooBaba  11 месяцев назад +3

      Most Welcome :)

  • @Travelwith_nm
    @Travelwith_nm 2 года назад +2

    sir pls sir pls sir python sikahye pls sir 😢😢😭😭😭😭😭😭😭😭😭😭

  • @shubhamtrivedi6267
    @shubhamtrivedi6267 2 года назад +3

    Sir can you upload simple and complex view tutorial of SQL.It will clear more doubts regarding the concept of Simple and complex view

  • @abdulqadar771
    @abdulqadar771 3 года назад +1

    Great teaching Sir

  • @mahanishpanda878
    @mahanishpanda878 2 года назад +2

    create a table with attributes student name roll no and city and find student living in same city

  • @junejarijvan6310
    @junejarijvan6310 2 года назад +1

    Thank you for this free course.😍 And love from India 🇮🇳

  • @bhagirathiverma2627
    @bhagirathiverma2627 Год назад +1

    Thank you sir😇😇😇😇😇

  • @aniketkadam4167
    @aniketkadam4167 2 года назад +2

    How to find '_' within 2 names ' Praveen_Patil'

    • @DeepakYadav-cx3vg
      @DeepakYadav-cx3vg Год назад +1

      Select * from tablename
      Where Name=Praveen OR name=Patil;
      Note name=column name

  • @zaib5263
    @zaib5263 4 года назад +4

    I have 3 values
    Rohan
    Salman khan
    Salim khan
    When i use "%n"
    I only get one result rohan
    Can u say Y others r missed ?
    Space between words can be reason?

    • @YahooBaba
      @YahooBaba  4 года назад

      Paste ur full command here. Space between words is not a reason

    • @zeeshanrahman481
      @zeeshanrahman481 2 года назад

      @@YahooBaba even i encountering that problem

    • @zeeshanrahman481
      @zeeshanrahman481 2 года назад

      i got it there is space after the last letter we dont get the name example "salmankhan "

  • @getknowledgebite3413
    @getknowledgebite3413 2 года назад +1

    Last wale m error h -------------"_oy%" this is correct Operator

  • @055sachdevaabhishek3
    @055sachdevaabhishek3 Год назад +3

    here is the best sql tutorial in youtube

  • @mohammadadilkhan6225
    @mohammadadilkhan6225 2 года назад +3

    Sir very nice, please give us any project where we could face this challenges to make any table and could improve our skill.
    Please if you have notes so share with us.

  • @mhtabhussain157
    @mhtabhussain157 2 года назад +2

    what if I have written "student name" instead of "name"
    and to search in 'student name' starting letter s (s%)

  • @manishkushwaha-je6xy
    @manishkushwaha-je6xy 3 года назад +1

    hello sir I hope you are good ;
    sir I have a confusion that is what the difference between SQL and MySQL
    sir Please reply!!!!!!!!!!!!!!!!!!!!!!

    • @YahooBaba
      @YahooBaba  3 года назад

      MySQL is a database like Oracle, MSServer, MsAccess etc. but SQL is a commands to work with databases. SQL is a common commands used in every database.

    • @manishkushwaha-je6xy
      @manishkushwaha-je6xy 3 года назад

      @@YahooBaba thank you sir..
      sir plz make a full tutorial on wordpress

    • @manishkushwaha-je6xy
      @manishkushwaha-je6xy 3 года назад

      @@YahooBaba thank you for your kind information Sir!!!!!!!!!!!!!

  • @shreejanarayan8691
    @shreejanarayan8691 3 года назад +2

    How can we search _ and % using like.. those symbols are considered as characters.. but how to search records with _ and % in it
    Please help

  • @wasyul6333
    @wasyul6333 Год назад

    Excellent

  • @mdzahidfaran7743
    @mdzahidfaran7743 3 года назад +8

    Thankyou so much Sir. I also want to suggest everyone who are reaching to this to watch whole series of MySQL. You have cleared all my doubt. Thankyou once again sir.

  • @akashkamble4684
    @akashkamble4684 2 года назад +1

    sir unix per video karo sir please

  • @premanandasamal2699
    @premanandasamal2699 3 года назад +3

    The channel will grow i am damn sure about it looking at the content. Thank u sir

  • @Sans_K5
    @Sans_K5 2 года назад

    thanks_Sir💜

  • @huzaifaramzan6503
    @huzaifaramzan6503 3 года назад +1

    sir, I want to learn c# can you please make a video series of c#

    • @YahooBaba
      @YahooBaba  3 года назад

      Can't possible this year

  • @aliisrar9676
    @aliisrar9676 3 года назад

    great sir

  • @syedshaheryarrizvi2659
    @syedshaheryarrizvi2659 2 года назад +1

    select * from doctors_sh
    where binary dr_name like 'r%';
    binary me error araha ha..

  • @sugammehta0301
    @sugammehta0301 3 года назад +1

    %am%. Means. "am" should come anywhere between to John Abraham mai "am," to last mai aa rha h yeh kaise aa rha😕?? Pls tell

    • @tabrez_zeta
      @tabrez_zeta 3 года назад

      %am% Ka meaning
      Starting me ho ya bich me ho ya end me ho.👍👍

  • @aniketkadam4167
    @aniketkadam4167 2 года назад +1

    How to solve this query??

  • @premanandasamal2699
    @premanandasamal2699 3 года назад +3

    The best tutorial i found😍

  • @ShahzaibKhan-wh5hh
    @ShahzaibKhan-wh5hh 4 года назад

    nice nice nice tusi great hooo

  • @shahzaibidreesahmed4827
    @shahzaibidreesahmed4827 Год назад

    Great

  • @SB-wc6fd
    @SB-wc6fd Год назад +1

    How to find % in column?

  • @ANKITPRAJAPATI-iq7mb
    @ANKITPRAJAPATI-iq7mb 4 года назад

    Owsm sir....

  • @Sumantkrmishra
    @Sumantkrmishra Год назад +2

    Fantastic tutorial....your way of teaching is very interesting and crystal clear.

  • @technicaltech8141
    @technicaltech8141 Год назад +1

    this playlist sufficient for become sql developer plz answer me

    • @YahooBaba
      @YahooBaba  Год назад

      Yes this playlist is sufficient. Even I am using same SQL methods for last 19 years as a Web Developer.

  • @YazmanBwp
    @YazmanBwp 3 года назад +5

    thank you for excellent tutorial ... love from Pakistan

  • @niteshchaurasiya1531
    @niteshchaurasiya1531 3 года назад +2

    Very nice sir 🙏

  • @ghulammuzzamil9690
    @ghulammuzzamil9690 6 месяцев назад +1

    bht acha clear kya aap NY sir

  • @TechnicalScienceCreation
    @TechnicalScienceCreation 2 года назад +1

    Sir g how can we freelancing using dbms

    • @YahooBaba
      @YahooBaba  2 года назад

      For Freelancing you have to learn any server side language with MYSQL. You can learn PHP or Python or NodeJS which are trending languages these days.

  • @vandanashakya6135
    @vandanashakya6135 3 месяца назад +1

    ❤❤❤❤❤

  • @TahaAli-cg4wj
    @TahaAli-cg4wj 4 года назад +1

    tell me how many thing i know to become best developer i have learn html css and php tell me other courses and php have future there is any other language to have best future

    • @YahooBaba
      @YahooBaba  4 года назад

      I think you must learn JavaScript and jQuery.

    • @TahaAli-cg4wj
      @TahaAli-cg4wj 4 года назад

      @@YahooBaba love you sir and thank you very much sir

  • @anjeshravi8
    @anjeshravi8 4 года назад +1

    Sir please make a video on Jquery Ajax with php CRUD

    • @YahooBaba
      @YahooBaba  4 года назад +2

      Anjesh I have already noted these videos for my PHP course .... so you have to wait few days :)

  • @TahaAli-cg4wj
    @TahaAli-cg4wj 4 года назад +1

    there is any microsft certified course for web devoloper to help us in this field

    • @YahooBaba
      @YahooBaba  4 года назад +1

      Their is not certification of web developer but one certification is for ASP dot net developers. See their is no need of certification for web development because no one see you certificate according to my 16 years of experience.

    • @TahaAli-cg4wj
      @TahaAli-cg4wj 4 года назад

      love you sir :) :)

  • @mayuraugad1445
    @mayuraugad1445 Год назад +1

    Mindblowing

  • @financewithsom485
    @financewithsom485 3 года назад +1

    rm reminds me rm from bts

  • @TWNOGaming
    @TWNOGaming Год назад

    thnk you

  • @nidhisingh151
    @nidhisingh151 Год назад

    Plz make video on python.

  • @knowledgekibaten7758
    @knowledgekibaten7758 3 года назад +1

    hello sir,
    how to add space in column name?

    • @YahooBaba
      @YahooBaba  3 года назад

      By doing drag n drop the column name header

  • @pradeepbehera599
    @pradeepbehera599 Год назад +1

    Tq dowt are clear

  • @Imran_kpk
    @Imran_kpk 2 года назад +1

    Thanks for your absolutly right teaching

  • @basantanembang4377
    @basantanembang4377 7 месяцев назад

    thank you Sir

  • @fahadmaqsood5636
    @fahadmaqsood5636 3 года назад

    SIr what is query string

  • @ManishPandey-ok2nz
    @ManishPandey-ok2nz 4 года назад +1

    Sir please notes

  • @Rehan_Official121
    @Rehan_Official121 Год назад

    Anyone notice the last pattern Like '_oy' correctly is '_oy%'

  • @gotisavan7922
    @gotisavan7922 2 года назад

    video controls par sir video banaona

  • @bindiyababu804
    @bindiyababu804 2 года назад +1

    Best teacher ❤

  • @girishpandey9976
    @girishpandey9976 4 года назад +1

    Thanks for valuable information sir

  • @YasirArfat-lg2et
    @YasirArfat-lg2et 3 года назад

    Sir thanks watching in 2021 love you 😘

  • @shubhamtalekar3612
    @shubhamtalekar3612 3 года назад +1

    Hii BRO ye error muze mere programme araha he pls can you explain me ki is ka syntax me kese likhu or ye kya araha he...
    Exception in Tkinter callback
    Traceback (most recent call last):
    File "C:\Users\stale\AppData\Local\Programs\Python\Python39\lib\site-packages\mysql\connector\connection_cext.py", line 506, in cmd_query
    self._cmysql.query(query,
    _mysql_connector.MySQLInterfaceError: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pharmacy where RefLIKE5%' at line 1
    During handling of the above exception, another exception occurred:
    Traceback (most recent call last):
    File "C:\Users\stale\AppData\Local\Programs\Python\Python39\lib\tkinter\__init__.py", line 1892, in __call__
    return self.func(*args)
    File "E:\pharma\pharmacy_pro.py", line 578, in search_data
    my_cursor.execute("select * pharmacy where " +str(self.search_var.get())+"LIKE"+str(self.searchTxt_var.get())+"%")
    File "C:\Users\stale\AppData\Local\Programs\Python\Python39\lib\site-packages\mysql\connector\cursor_cext.py", line 269, in execute
    result = self._cnx.cmd_query(stmt, raw=self._raw,
    File "C:\Users\stale\AppData\Local\Programs\Python\Python39\lib\site-packages\mysql\connector\connection_cext.py", line 510, in cmd_query
    raise errors.get_mysql_exception(exc.errno, msg=exc.msg,
    mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pharmacy where RefLIKE5%' at line 1

  • @anjeshravi8
    @anjeshravi8 4 года назад

    Sir Jquery ajax Post method Back end php ke uper bhi video banaye sir

  • @hamzaqureshi391
    @hamzaqureshi391 2 года назад

    GREAT

  • @muhammadwajid3867
    @muhammadwajid3867 3 года назад +1

    mysql is almost like mssql

    • @YahooBaba
      @YahooBaba  3 года назад +2

      All SQL databases are almost same because they uses common SQL commands. Popular SQL databases are Oracle, MySQL, MsServer, MsSQL, Postreql, MsAccess etc.

  • @Call-Me-Chaudhary
    @Call-Me-Chaudhary 6 месяцев назад

  • @shanzayashfaque4604
    @shanzayashfaque4604 11 месяцев назад

    Owesome!! Thanks

  • @princeagrawal
    @princeagrawal 3 года назад

    thankyou ♥

  • @aliisrar9676
    @aliisrar9676 3 года назад

    sir hum double underscore ke bad ek value dete h phr percentage ka sign uske bad koi word le skte h __i%r aise

  • @JustForProgrammers
    @JustForProgrammers 4 года назад

    IP Address par video bano

  • @yogeshsaini254
    @yogeshsaini254 2 года назад

    Mast

  • @yogeshsaini254
    @yogeshsaini254 2 года назад

    Thanks sir

  • @hassenbabu2136
    @hassenbabu2136 Год назад

    Excellent classs sir..

  • @abhishekkumardubey2298
    @abhishekkumardubey2298 Год назад

    Wonderful sir

  • @Dheerajkushwaha1-o7z
    @Dheerajkushwaha1-o7z 4 года назад

    Thanks

  • @akashkamble4684
    @akashkamble4684 2 года назад

    Nice Sir Nice Teaching Comment toh banti hai

    • @YahooBaba
      @YahooBaba  2 года назад

      Thanks and Welcome :)

  • @ajaysinghchauhan1021
    @ajaysinghchauhan1021 4 года назад

    :) thanks

  • @DeepakGupta-hj2dv
    @DeepakGupta-hj2dv 4 года назад +1

    SQL kab tak complete hoga..?

    • @YahooBaba
      @YahooBaba  4 года назад

      This Month

    • @ANKITPRAJAPATI-iq7mb
      @ANKITPRAJAPATI-iq7mb 4 года назад

      @@YahooBaba
      Sir sql ke bad kis video Aygi...

    • @YahooBaba
      @YahooBaba  4 года назад

      Videos of PHP with MySQL with project.

    • @ANKITPRAJAPATI-iq7mb
      @ANKITPRAJAPATI-iq7mb 4 года назад

      @@YahooBaba
      Sir vase wordpress ka tutorials ane me kitna time or lgega....

    • @YahooBaba
      @YahooBaba  4 года назад

      Next Year 2020

  • @nnsalaria2851
    @nnsalaria2851 Год назад

    Thanku sir❤

  • @jojven7514
    @jojven7514 Год назад

    AWESOME VDO

  • @dhruvrajsinhjadeja-vfxarti3085
    @dhruvrajsinhjadeja-vfxarti3085 4 года назад +2

    Thanks for this video sir :)

  • @ashwanigupta2838
    @ashwanigupta2838 3 года назад

    Nice Explaination

  • @nehajha5393
    @nehajha5393 3 года назад

    Excellent video

  • @hondaxblade2127
    @hondaxblade2127 3 года назад

    Jai Hind sir 😊

  • @Sans_K5
    @Sans_K5 2 года назад

    student of year goes to "Ram Kumar"🙃

    • @cybxtra
      @cybxtra Год назад

      😂😂😂