Find all rows using some Unicode range (e.g. Cyrillic characters) with PostgreSQL?

Question

How to find all rows of a PostgreSQL table containing characters in some Unicode ranges, for example Cyrillic characters?

Answer 1

I thought! For Cyrillic:

SELECT * FROM "items" WHERE (title SIMILAR TO '%[\u0410-\u044f]%') 

I got a range from http://symbolcodes.tlt.psu.edu/bylanguage/cyrillicchart.html . Characters have hexadecimal objects А before я which are also my numbers above.

Answer 2

If you install the pgpcre extension, you can use this expression:

 SELECT * FROM items WHERE title ~ pcre '\p{Cyrillic}';