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.

推荐答案

相当慢，但包含任何词的工作方法:

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屋！