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..Please Help.
Thanks in Advance
Regards
Ahsan

try da manuel

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 ?

so what have you tried?
have you refined your regexp.

on the face of it the manual seems relatively self explanitory

i tried the following query
SELECT * FROM table_name WHERE column_name NOT REGEXP '[a-z]'

but it shows only those records that contain anything except a-z and does not includes those records that includes a-z and any other thing.

WHERE column_name REGEXP '[^a-z]'