Welcome to WebmasterWorld Guest from 23.20.230.24

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)

10+ Year Member



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)

10+ Year Member



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"

 

Featured Threads

Hot Threads This Week

Hot Threads This Month