Welcome to WebmasterWorld Guest from 54.224.160.42

Forum Moderators: open

Message Too Old, No Replies

SQL - Combining 'LIKE' and 'IN' operators?

combining the functinality of both

     
8:35 pm on Oct 25, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Jan 5, 2005
posts:134
votes: 0


Is it possible to combine the functionalities of the LIKE operator and the IN operator into one function?

example: (how do I make this concept into a functional query)

Select * from table1 where PhoneNumber IN ("%1234", "%5678");

This query will not return any results becuase, given the syntax, it will search for the literal string "%1234" instead of treating it as a wildcard operator as it would with a LIKE statement

thank you
-Mike

8:47 pm on Oct 25, 2005 (gmt 0)

Preferred Member

10+ Year Member

joined:Oct 1, 2004
posts:607
votes: 0


Select * from table1 where PhoneNumber IN ("%1234", "%5678");

You don't say which database you're using (MySQL judging by the double quotes), but with all the usual suspects the simplest, SQL-ish way to do this is with OR:

Select * from table1 where PhoneNumber LIKE "%1234" OR PhoneNumber LIKE "%5678"

If you have further conditions in the where clause, use brackets, e.g.
Select * from table1 where (PhoneNumber LIKE "%1234" OR PhoneNumber LIKE "%5678") AND widget="blue"