On Thu, 14 Sep 2006, Ravi Kumar. wrote:
> Is there a way to specify wildcard inside values of an in clause. I want to
> be able to do this:
>
> select id, name from tableName where name in ('a%', 'b%', 'c%');
>
> instead of doing
>
> select id, name from tableName where name like 'a%' or name like 'b%' or
> name like 'c%';no. You have to use LIKE. Thomas Spahni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
