SQL SELECT WHERE field contains words

Question

I need a select which would return results like this:

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

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.

Answer 1

• To include any of the word use this query:

SELECT * FROM Table

WHERE column1 LIKE '%word1%'

OR column1 LIKE '%word2%'

OR column1 LIKE '%word3%'

• If you want all the words to be present, then use this code:

SELECT * FROM Table

WHERE column1 LIKE '%word1%'

  AND column1 LIKE '%word2%'

  AND column1 LIKE '%word3%'