需要从SQL中的多个字符串找到结果

Question

以下是我的表输出。我想通过使用结果中包含的多个字符串找到结果。

例如：我需要获得包含["如何"，"，"您"]

的结果

column A
-----------------
how are you?
How about you?
how are you going?
how are you doing?
What up?
What is up?
Are you alright?

Answer 1

中的任何一个单词

select * from tablename where [column A] like '%how%' or [column A] like '%are%' or [column A] like '%you%' 

所有单词

select * from tablename where [column A] like '%how%' and [column A] like '%are%' and [column A] like '%you%' 

所有单词一起

select * from tablename where [column A] like '%how are you%'