Hi Jeff,
The search doesn't work this way otherwise if a user searched using the phrase "Restaurant in London", you would get search results on any of the words like "in".
One method to do this would be to write custom code to break the search query up by spaces, then put the individual words into an array. Next a custom WHERE statement using LIKE to return the results. A further step would be to create a list of common words to remove from the search array such as: in, a, the, it, is, etc.
If you are interested in getting this done through consulting, send Ross an email with details to consulting@interactivetools.com.
Cheers,
Damon Edis - interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/