SQL query with like for multiple values from comma separated string in WHERE clause

Asked Jan 20 '22 at 16:31

Active Jan 20 '22 at 16:31

Viewed 285 times

I have a query where I want to filter by multiple values with like.

I have read the answer in below link:

The only difference I have here is I don't have values that I want to look for as stated in the answer as below:

WHERE CONTAINS(t.something, '"bla*" OR "foo*" OR "batz*"')

The values I want to query is coming from splitting a string:

select value from string_split(@String_With_Commas,',')

So how can I create the below query's second part (containing OR's) coming from the splitted string values ?

  WHERE CONTAINS(t.something, '"bla*" OR "foo*" OR "batz*"')

asked Jan 20 '22 at 16:31

rick_87394

STRING_SPLIT returns a table, does it not? So how would you formulate a query using a table? Perhaps `IN`? Do you have full-text indexing implemented on the column? – SMor Jan 20 '22 at 16:38
Yes but as stated in the answer I have mentioned you can't combine IN with LIKE – rick_87394 Jan 20 '22 at 16:40
Yes that column is Full-text indexed – rick_87394 Jan 20 '22 at 16:40
But you *can* combine `LIKE` with `EXISTS`. Though that won't use your Fulltext index. – Thom A Jan 20 '22 at 16:40

0 Answers0