A
A
Anton2016-11-25 14:25:06
PostgreSQL
Anton, 2016-11-25 14:25:06

How to display only English table entries?

The table has many entries in both Russian and English.
Can you please tell me how to display records that contain only English characters in the description field?
Something didn't work for me using: SIMILAR TO. Displays or not all, or with Russian text.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Shelemetiev, 2016-11-29
@zoroda

If you need a case-insensitive search:
select * from table where description ~* '[a-z]'

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question