PDA

View Full Version : SQL LIKE Operator


mokujin
12-29-2009, 08:37 PM
Hello,
I have a question,
How do I have SQL LIKE Operator for more than 1 columns?
example I tried:
SELECT username
FROM user
WHERE username LIKE ('%tav%','%mok%','%ronal%')

but it does not work
can you help me? thank you

Tommy Boy
12-30-2009, 04:22 AM
WHERE username LIKE ('%tav%')
OR username LIKE ('%mok%')
OR username LIKE ('%ronal%')