| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
|SQL - Combining 'LIKE' and 'IN' operators?|
combining the functinality of both
| 8:35 pm on Oct 25, 2005 (gmt 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
| 8:47 pm on Oct 25, 2005 (gmt 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"
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved