Partials With IN

[cap97]

So with a table I can go:

 SELECT * FROM cartoons WHERE name IN ('bugs bunny','daffy duck','marvin the martian');

which will, of course, pull the three names above from the table. Is there a way to use the IN command when only providing partials? Like:

 SELECT * FROM cartoons WHERE name IN ('bugs','duck','martian');

The above would then search the table to give me any name containing "bugs", "duck" or "martian". Of course, it actually won't do that and that's why I'm here. 😉 Is there a way to get that to happen? Merging LIKE with IN?

[bastien]

Don't think you can, its usually IN (with the IN part coming from a subs-select with definite values) or LIKE with partials....

[Sxooter]

I think you'd have to rearrange it to use like:

select * from table where field1 like 'abe' or field1 like 'ben' or field1 like 'marvin';

[Sxooter]

Note that with regex capability, you could make it a bit shorter, but it will actually usually run slower than like, which is a much simpler comparison engine.