MySQL Database Tutorial – 13 – How Search Engines Work




Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …

Original source


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

  1. 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 ! 🙂

  2. '%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.'

  3. 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

Leave a Reply