Sql query with In and like operator or any other way around

Question

I was trying a query like this one, select * from table where column like in ('abc%','bcd%', '%cde') but not working. Basically I cannot use like operator with Or as I don't know how many values i will get at runtime. This values are coming from a subquery.

Requirements are to match with multiple values with pattern. But number of multiple values not known.

Possible duplicate of [Using SQL LIKE and IN together](https://stackoverflow.com/questions/2318126/using-sql-like-and-in-together) — Utkarsh Dubey, Mar 04 '23 at 14:52
`values are coming from a subquery` - `from table inner join (subquery) on column like subquery.column`? — GSerg, Mar 04 '23 at 14:54

score 0 · Answer 1 · answered Mar 04 '23 at 15:13

0

I recommend to use “union all”, seperate select query for each like statement, as below:

select * from table where column like 'abc%'
Union All
select * from table where column like 'bcd%'
Union All
select * from table where column like '%cde'

answered Mar 04 '23 at 15:13

jepozdemir

260
1
4

Sql query with In and like operator or any other way around

1 Answers1