You probably want to look into using RLIKE or REGEXP.
SELECT id,name FROM tabename WHERE name RLIKE '^[abc]'
- Original Message -
From: "Ravi Kumar." <[EMAIL PROTECTED]>
To:
Sent: Thursday, September 14, 2006 7:37 AM
Subject: Like inside in clause
Dear F
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
Dear Friends,
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%';
