I have this data (eg.) "..........big fat buddy......." on the database . If
a person enter "big buddy" in the search form , the ".......big fat
buddy........." data will not be found . Any suggestion ?
select * from table where data like "%keywords%";
You can break up the search terms into words and do
...data LIKE '%$keyword[0]%' OR data LIKE '%$keyword[1]%'...
This will be slow though. You could also do full text searches if you are using MySQL. Have good indexes for whichever route you go.
Larry