开发者

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.


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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜