SQL SELECT WHERE字段包含单词 [英] SQL SELECT WHERE field contains words

问题描述

我需要一个可以返回如下结果的选择:

I need a select which would return results like this:

SELECT * FROM MyTable WHERE Column1 CONTAINS 'word1 word2 word3'

我需要所有结果，即包括带有'word2 word3 word1'或'word1 word3 word2'或三者的任何其他组合的字符串.

And I need all results, i.e. this includes strings with 'word2 word3 word1' or 'word1 word3 word2' or any other combination of the three.

所有单词都必须包含在结果中.

All words need to be in the result.

推荐答案

相当慢，但是可以包含 any 个单词的有效方法:

Rather slow, but working method to include any of words:

SELECT * FROM mytable
WHERE column1 LIKE '%word1%'
   OR column1 LIKE '%word2%'
   OR column1 LIKE '%word3%'

如果您需要显示所有个单词，请使用以下命令:

If you need all words to be present, use this:

SELECT * FROM mytable
WHERE column1 LIKE '%word1%'
  AND column1 LIKE '%word2%'
  AND column1 LIKE '%word3%'

如果您想要更快的速度，则需要研究全文搜索，这对于每种数据库类型都是非常特定的.

If you want something faster, you need to look into full text search, and this is very specific for each database type.

这篇关于SQL SELECT WHERE字段包含单词的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！