I want to search on more than one field using LIKE

[Mayoor]

Can anyone help with the syntax?

So far I have

SELECT * FROM nsc_community WHERE users LIKE %Mike

however I'd like to also search the desription field as well. Would it be as simple as separating the field names with a comma?

 

[mimi2]

i am not sure i understand.
if you want to filter on nsc_community and description fields:

SELECT * FROM nsc_community WHERE users LIKE '%Mike%' and description like '%california%'

 

[Mayoor]

OK basically the user will enter a search string, and the SQL statement must look in several fields for that string.

Mayoor

 

[Mayoor]

Also is there any way i can use a wildcard to represent every field in the database?

 

[rw2003]

Try this:
SELECT * FROM nsc_community WHERE users LIKE '%Mike%' OR description like '%Mike%'

This will search both fields for occurances of '%Mike%'

 

[mimi2]

there is a link here to
How to search all columns of all tables in a database for a keyword

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm