Re: LIKE with an IN
From: Madhu Konda <mkonda_at_dnt.dialog.corp.com>
Date: 1996/01/20
Message-ID: <4dpfnb$j3e_at_iserv.dnt.dialog.com>#1/1
Date: 1996/01/20
Message-ID: <4dpfnb$j3e_at_iserv.dnt.dialog.com>#1/1
How about using
select col1
from table_name
where col1 like 'your_wildcard_search%'
or col1 like 'another_wildcard_search%
or ....so on
The oracle optimizer is going to convert the IN operator statement into OR statements anyway.
Hope this helps
- Madhu Konda