I have a site that store's different user's locations. I have fields for city, state, and neighborhood. I need to create a search feature that takes one input query and searches through these three fields. Here is an example:

Search for "Encinitas California"

Possible results:
City - Encinitas
State - California
Neighborhood - Cardiff

City - San Diego
State - California
Neighborhood - Encinitas

All query words must be contained in at least one of the three fields.

I cannot figure out how this could be done. I thought about creating a fourth field combining all the data as "Encinitas California San Diego" and having the query reference that field using "like", but it did not work how I needed it to.

Is there a way to accomplish this?

Thanks for your help.

you'll have to break your search string into words using your application language (php?) generate as many of these as you have words in the search string

Thanks a bunch! That was exactly what I needed.