ecabrera Posted October 20, 2013 Share Posted October 20, 2013 ok so i have a search bar and when i search for keywords it doesnt get all the keywords here is how its setup SELECT * FROM videos WHERE `tags` LIKE '%$search%' OR `name` LIKE '%$search%' It doesn't get all the keywords that are in tags for example if i search "soccer player in new york" the tags are like "soccer,player,world,mls,futbol,spain,ronaldo" it returns 0 videos if i search "Soccer" it returns 100 videos Quote Link to comment Share on other sites More sharing options...
Solution Ch0cu3r Posted October 20, 2013 Solution Share Posted October 20, 2013 (edited) I don't think LIKE can take multiple values to search. You have to perform like on each keyword. eg SELECT col FROM table WHERE col LIKE '%keyword1%' OR col LIKE '%keyword2%' OR col LIKE '%keyword3%' etc.. Edited October 20, 2013 by Ch0cu3r Quote Link to comment Share on other sites More sharing options...
QuickOldCar Posted October 21, 2013 Share Posted October 21, 2013 LIKE is a simple search, using AND versus OR yields different results as well. If wanted a more advanced search try using full-text search in booleon mode http://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html Somewhere here in phpfreaks is some examples and functions to help you along whichever method you decide on. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.