Mysql query to select a column with only alphabetical characters

Question

I need to display records from mysql database where a particular column has only alphabets.

eg,

Table Name: data

 column
 abcde
 12345
 xyz
 123

so the output should be abcde and xyz only. So far i tried using pattern match but no luck

here is what is use yet SELECT * FROM listing WHERE Zip LIKE '[^a-zA-Z]'

Answer 1

Try this code

SELECT * FROM listing WHERE Zip REGEXP  '^[A-z]+$'

Answer 2

Try regexp:

SELECT * FROM listing WHERE Zip REGEXP '^[a-zA-Z.]+$'