MySQL Database Tutorial – 13 – How Search Engines Work

[ad_1]
Facebook –
GitHub –
Google+ –
LinkedIn –
reddit –
Support –
thenewboston –
Twitter –


Posted

in

by

Tags:

Comments

41 responses to “MySQL Database Tutorial – 13 – How Search Engines Work”

  1. A Kane Avatar

    Hello.  I'd like to order a book about making babies and a shampoing, please.

  2. Mohamed Ali Avatar

    Tell me the link to download these files the Items table and Customers Table. Thanks for the tutorials sir

  3. TNTSquid Avatar

    If search engines was working like this…… they get hacked long time ago…. (SQL injection).. But good enough for satisfying those lazy teachers

  4. Aaronsky berducido Avatar

    thanks for your help thenewboston

  5. Science is Awesome!! Avatar

    i hate cliffhangers. LOL. i'll stay tuned for your next video on more wildcards.

  6. AutoPilot69 Avatar

    Can some send the link to the exercise files please? thanks

  7. Lowinator Avatar

    Whats up with the audible high pitched sound thats in every video of this series?

  8. clinton chogo Avatar

    selling used diapers? dude

  9. Baqir Khan Avatar

    If he clicks on the EDIT button instead of clicking on the SQL button which gives a default (SELECT * FROM `items` WHERE 1) then he will get his previous command and can edit it and explain it further. Might save time ! 🙂

  10. tejal rathod Avatar

    can i combine more then one REGEXP at once ?

  11. ken ch Avatar

    Lol new iPad stolen from best buy

  12. Scene & Heard TV Avatar

    New jacket… New computer… NEW BOSTON !!!! 

  13. Perpetual Avatar

    How do we create tables??

  14. Aaron Dixon Avatar

    I was about to give up on SQL until I saw your videos! I feel to sleep in college on this stuff and now I'm starting to get a clear understanding from your perceptive. Thanks!

  15. Krazor Avatar

    566 bids on a pair of gym socks xD

  16. slimj olshea Avatar

    lol bucky is so funny

  17. Neil Brewer Avatar

    WTF.. who sells used diapers lol

  18. Manami Tamura Avatar

    '%boxes' implies that the string ends in 'boxes,' while '%boxes%' would imply that the word 'boxes' could be anywhere in the string.

    That means that the query you wrote would only show the rows where the column 'name' ends with 'boxes.'

  19. Radoslav Andonov Avatar

    One question bucky I was playing around with the queries and this query return 0 rows
    SELECT name FROM items WHERE name LIKE '%boxes'
    and I can't figure out why
    SELECT name FROM items WHERE name LIKE '%computer' works as expected.
    Is it because infront boxes there are numbers ,however column type is VARCHAR so all name is just a string

  20. nightfoz Avatar

    new gym socks… 566 bids!xD These socks must feel like heaven

  21. Tamás Demeter Avatar

    "New is always better" 😀

  22. Herp Derpingson Avatar

    I can type
    WHERE name = "new %"
    instead of
    WHERE name LIKE "new %"
    Is there any problem if I do so?

  23. Herp Derpingson Avatar

    Nope, you cant fool me XD
    Your "bits lie" 😉 Get the pun?

  24. Cliff Skelliter Avatar

    @lofmovh I've hit the jackpot with a new method making about $1300 a day. If you find a niche thats eager to buy your bank account will go mental. Check out this course before he goes private => bit.ly/P7tg4d?=xgeyfi

  25. glogalswaze Avatar

    7 boxes of frogs or 48 boxes of frogs decisions decisions……

  26. Drunk Arsonist Avatar

    Theres a used toilet in the list somewhere 😐

  27. TheVarmari Avatar

    I made a table. It contained firetruck.
    SELECT car FROM cars WHERE car LIKE 'f%uck'
    FIRETRUCK!!!

  28. TheVarmari Avatar

    "New gym socks" – 2.34 – 566 bids…

  29. Hidden_C_Hall Avatar

    "new ipad stolen from best buy" best deal ever

  30. Darkinin Avatar

    Did you divide the price of the Brand New iMac by 20, Bucky?

  31. Rougang Tang Avatar

    Its just cooly coolest coolness!

  32. Michael Hawkins Avatar

    @The1453cCc Probably because it would be annoying for a search engine to say DOG isn't the same as dog/Dog/dOg/dOG…

  33. ot0 Avatar

    interesting that mysql isn't case-sensitive in STRINGS. Almost every progr.language is case-sensitive in strings, oracle is also.

  34. erlkoenig Avatar

    "New iPad stolen from BestBuy!" 😀

  35. fyrstikknerd Avatar

    Haha! New gym socks to $2.34 – 566 bids!! haha

Leave a Reply

Your email address will not be published. Required fields are marked *