I am looking for some help/example code on the best way of writing a mySQL query to perform a keyword search on several fields of a table.
I want it to be quite sophisticated so that it doesn't just find exact string pattern matches. So "yellow bike" will return results like "yellow bike" as well as "yellow mountain bike" etc...
I know you need to split the keywords into an array and loop through them but I'm not exactly sure how to go about it, any help would be appreciated.
thanks,
Leigh
