How do I search for all rows containing a given unicode character in Postgres

Question

I am after all cells containing the 'LINE SEPARATOR' (U+2028) unicode point. Normally this is encoded as \u+2028 or something similar. However googling how this translates to SQL has given various options none of which seem to work ((N'2028'), set @hexstring = '2028';, vchar(2028))

SELECT * FROM myTable WHERE desc LIKE '% [SOME WAY TO ESCAPE U+2028 ] %'

Answer 1

ANSI SQL answer, may or may not work with Postgresql.

SELECT * FROM myTable WHERE desc LIKE U&'%\2028%'

Answer 2

Alternative solution using regexp:

select * from mytable where desc ~ '\x2028';