LIKE operator to search for characters?

Question

PostgreSQL

Hello.

I wondered, using the LIKE operator, you can find all the characters and letters without listing them?
The table is all in VARCHAR and you need to find everything that is not numbers!

Thank you Michael

Answer 1

I think it would be more practical to use regular expressions . This is how you can select all records where the column column does not contain numbers:

SELECT * FROM your_table WHERE column ~ '^[^0-9]+$'