Need to find result from multiple string in SQL

Question

The below is my table output. I wanted to find the result with using multiple string that contains in the result.

for example: I need to get result that contain ["how", "are", "you"]

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

Does the result has to contain all the 3 words or just one of those words ? — Pரதீப்
– Pரதீப், Commented Oct 2, 2017 at 3:00
Need to know both the query 1) With anyone word 2) With all the words — Saurabh Raman
– Saurabh Raman, Commented Oct 2, 2017 at 3:02
As Tim said in comments to deleted answer, you can use full text search stackoverflow.com/a/6506489/7974050 — Amit Kumar Singh
– Amit Kumar Singh, Commented Oct 2, 2017 at 3:09
select * from tablename where [column A] like '%how%' or [column A] like '%are%' or [column A] like '%you%' — nobody
– nobody, Commented Oct 2, 2017 at 3:29

nobody · Accepted Answer · 2017-10-02 03:36:42Z

1

Any one of the words

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

All the words

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

All the words together

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

answered Oct 2, 2017 at 3:36

nobody

11.1k8 gold badges51 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1