Forum Moderators: coopster

Message Too Old, No Replies

How do you use multiple LIKES

I have LIKE '%word' want to filter 2 things

         

ogletree

5:07 pm on Jul 13, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



I have LIKE working I just want to filter for several things I want to LIKE '%word1' and '%word2'

coopster

5:21 pm on Jul 13, 2004 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



You've got it.
SELECT * FROM table WHERE field1 LIKE '%word1%' AND field2 LIKE '%word2%';