SQL IN Statement using like syntax?
Posted
by StackUnderflow
on Stack Overflow
See other posts from Stack Overflow
or by StackUnderflow
Published on 2010-03-30T21:30:34Z
Indexed on
2010/03/30
21:33 UTC
Read the original article
Hit count: 272
sql
|sql-server
I would like to do something like this i.e., use wild card characters in the in clause:
SELECT * FROM mytable WHERE keywords IN ('%test%', '%testing%')
This is not supported in MS SQL.... Is there some other way to achieve it...
Looking for something other than:
SELECT * FROM mytable WHERE keywords like '%test%' or keywords like '%testing%' or.....
© Stack Overflow or respective owner
