OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
like in()

From: Octavian Rasnita (orasnitagmail.com)
Date: Fri Jan 25 2008 - 04:34:17 CST

Hi,

I can do:

where word in('one','two','three')

and I can also do:

where word like 'thr%'

Is there a way of combining these 2 ways?

I want to select something like:

where word like 'on%' or word like 'tw%' or word like 'thr%'

but using a single expression, without "or".

Is it possible to do this? To use something like

where word inlike('on%','tw%','thr%')

Thank you.

Octavian

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql