HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://eepurl.com/-8qtH Donate!: http://bit.ly/DonateCTVM2.
source
HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://eepurl.com/-8qtH Donate!: http://bit.ly/DonateCTVM2.
source
16 responses to “MySQL Tutorial 31 – How to Search your Database using Like and Wildcards”
Dude av got a test tomorrow. I went through the slides and coudnt even grasp anything. U just did what my lecturer couldnt for 2 weeks. U made it simple. Tnx ur a life saver
Hellow bro.. i have a problem in importing a csv file with a chinese letters on it. but after the importaiton in mysql is completed it does not display the chinese characters normally '???' but if i input the chinese characters inside the mysql it can display normally. hope you can suggest something… thanks..
@ 3:42 about BO … I laughed way to hard at that LOL
Watch series with autoplay: MySQL Tutorial 1 – What is MySQL @CalebCurry
Donations are greatly needed and appreciated! Click to donate: http://bit.ly/DonateCTVM2
_ % actually does have a use over just %. % will be 0 or more characters while _ % will be 1 or more characters and _ _ % will be 2 or more characters.
For example if you want to find all words that start with 'a' and are at least 4 characters long you can use a _ _ _ %.
Great! Thanks for the great comment and I'm honored that I was able to be of some help.
Hi Caleb I would just like to thank you for this series of videos I have been trying to teach myself MYSQL for a long time and have made more progress in a week with these than all my other info in two years you obviously teach at my adsorption level. At my time of life things don't go into storage as fast I have taught my self how to build websites and am pretty confident with gimp but MYSQL was just a mystery until I found your series.
Can you just let me the exact code for doing this. When im trying this out, im getting a null output.
this is what i've tried:
SELECT * FROM 'gym'.'members' WHERE 'first_name' LIKE '%bo';
I'm not too sure… lol
Does it work the same with dates?
Can anyone explain this BO joke to me?
great tutorial btw
That's so awesome!! Thanks for letting me know!
Thanks dude! I was able to tell an interviewer the other day I know MySQL (in part because of this series). He was impressed
I believe so. Give it a try.
when you use a % sign, does it also bring back 0 characters? ie will it return a record with "BO" ?
they all have BO! lol