RegExp Question

[IMAhsan]

Deall All,
Am a newbie to MYSql and am stuck with a problem, I want to pick all the records that contain anything else except a-z, this means that if a record contains a-z but also contains anything else like any symbol it should be included..Pleas e Help.
Thanks in Advance
Regards
Ahsan

[SLauren]

Please go through the following link:
http://dev.mysql.com/doc/refman/5.1/en/regexp.html

Hope it could help in matching your requirements.

Thanks,
Lauren

[IMAhsan]

I already knew about that link but as am a new to this so was not able to grasp all of this and i also i want this query as soon as possible, any body have the idea about it ?

[SLauren]

You can try like:
SELECT * FROM <table_name> WHERE <field> REGEXP '[^a-z*]';

Thanks,
Lauren