How to use character list wildcard [abc] in MySQL

[vinodxx]

Hello friends,

Here is my question for you.

How to use character list wildcard in MySQL.

Select * from customers where CompanyName LIKE '[abc]%'

Ref:
http://w3schools.com/sql/sql_wildcards.asp

This is not working in MySQL.
Can u please help me.

Regards,
Vinod

[chazzy]

that's not standard sql.

you could use regexp function in mysql to do a similar query.

[WebWarrior]

Check out MySQL's pattern matching (http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html) for more info.