How do you write a query with "multiple string/substring matching"? [duplicate]

Question

How do you write a query with "multiple string/substring matching"?

Example:

SELECT * FROM table WHERE column LIKE ('%BD%','%IND%','%PK%','%USA%')

Do you want to match any of the strings, or any combination of these strings in the columns? Also, what DBMS are you using - MySQL or Oracle? — shree.pat18
– shree.pat18, Commented Dec 11, 2014 at 7:41
Possible duplicate of mysql - stackoverflow.com/questions/4172195/mysql-like-multiple-values and oracle - stackoverflow.com/questions/1387612/… — Wundwin Born
– Wundwin Born, Commented Dec 11, 2014 at 7:42

Jens · Accepted Answer · 2014-12-11 07:41:24Z

2

Try this:

select * from table where column like '%BD%' or column like '%IND%'or column like'%PK%' or column like'%USA%'

answered Dec 11, 2014 at 7:41

Jens

69.6k15 gold badges107 silver badges133 bronze badges

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

Comments

Rusty · Accepted Answer · 2014-12-11 11:24:05Z

0

select * from table 
 where regexp_like(column,'BD|IND|PK')

answered Dec 11, 2014 at 11:24

Rusty

2,13812 silver badges13 bronze badges