CODEWITHSUNDEEP
sql
Sandy
Sandy

Reputation: 73

sql query: if any of the columns have even one word mentioned in a given array of words, select that entire row

I have the following sql query:

select distinct * from tableName where contains ( (column1, column2, column3), 'default' )

This works fine. Instead of looking at just one keyword 'default' is it possible to mention an array of words and if any of the columns have even one word mentioned in that array of words, select that entire row.

Upvotes: 2

Views: 89

Answers (1)

VoodooChild
VoodooChild

Reputation: 9784

select distinct * 
from tableName 
 where contains ( (column1, column2, column3), 'default' OR 'defalut2')

http://msdn.microsoft.com/en-us/library/aa258227%28v=sql.80%29.aspx

Upvotes: 1

Related Questions