twenty1

Hi,

I'm trying to figure out how to group LIKEs together, such as:

select * from A
where B like ('ccc', 'ddd', 'eee')

suggestions appreciated

ez2c

Here's my 2cents on this:

You will need to decide whether you want the conditions connected with ORs or ANDs. You should probably use wildcard characters (%); otherwise, each LIKE in effect becomes a strict equality, and then only the OR version even makes sense.

Find rows where B contains any one (or two, or three) of the three strings:

select *
from A
where B like '%ccc%'
or B like '%ddd%'
or B like '%eee%'

Find rows where B contains all three strings, in any order:

select *
from A
where B like '%ccc%'
and B like '%ddd%'
and B like '%eee%'

Find rows where B contains all three strings, in the given order:

select *
from A
where B like '%ccc%ddd%eee%'

cheers