I currently have the following that will search a field within my db for a mention of one word, but would like to know if it is possible that if a customer enter two words, rather than only output anything matching that particular format, it actually splits the words up and returns the result for both words not an exact match:
Currently have
WHERE title LIKE '%SEARCH TEXT HERE%'..
so if a user currently enter 'FISH' or 'FISH FOOD' then it will return only the columns that have that text within in it as it is.
What i would like to happen is if they entered more than one word then it actually splits that up and then searches and returns the results for all the separate words.
So 'FISH FOOD' would return all rows with the word fish or food with in and not just anything that matched 'FISH FOOD'
Using PHP and MySQL
Thanks
See Question&Answers more detail:os