How to select the rows which doesnot have digits in that.
Suppose id is 121.rr, how to seleect which selects the id's only which doesnot have numeric in it. That is, if id is fa with no numeric digits.
How to select only id's like fa and not 121.rr
SELECT * FROM table_name WHERE column_name NOT REGEXP '[[:digit:]]'
(I'm assuming MySQL, other DBMS's will vary in their regexp support/syntax.)
