[RESOLVED] mysql select query based on two fields?

[kpowning]

I have two fields in my table "users" one field is called "category1" and the other is "category2". I'm trying to build a mysql query selecting all users that either have category1 or category2 containing "dancer". So basically I want all results for category1 containing "dancer" and category2 containing "dancer" to show up.

Basically if they have "dancer" in either category they will show up for the query result. THANKS IN ADVANCE!

How can I build this query? I apprecaite any support on this...

[NogDog]

SELECT * FROM table_name WHERE category1 = 'dancer' OR category2 = 'dancer'

(Replace "*" with the actual columns you want to retrieve in the query.)

[kpowning]

THANK YOU FOR THE RESPONSE. I didn't realize you could use the "OR" in the query. IT WORKED :+)