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

Question

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, Dec 11 '14 at 07:41
Possible duplicate of mysql - http://stackoverflow.com/questions/4172195/mysql-like-multiple-values and oracle - http://stackoverflow.com/questions/1387612/how-can-i-introduce-multiple-conditions-in-like-operator — Wundwin Born, Dec 11 '14 at 07:42

score 2 · Answer 1 · answered Dec 11 '14 at 07:41

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 '14 at 07:41

Jens

score 0 · Answer 2 · answered Dec 11 '14 at 11:24

0

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

answered Dec 11 '14 at 11:24

Rusty

2 Answers2