I have a $string variable, and I use
SELECT * FROM db WHERE description LIKE '%$string%' OR headline LIKE '%$string%'
As seen, I want to search the two fields "description" and "headline" to see if the string variable matches any of them.
Problem is that I want it to match whole words!!!
Ex: If description contains "hello", It is enough if $string is an 'h'. this is not what I want.It has to match the whole word only!
I split the querystring into words for this? or what?