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.
Advertisement
Answer
x
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