How to display all rows from the database where some characters are used in the address column in addition to numbers, Latin and Russian letters, spaces?

Question

PostgreSQL

That is, here is the table table1.
It has an address column.

I need to output strings that use characters like slashes, dots, commas, plus signs, and so on.
In general, in addition to Russian or Latin letters and numbers with spaces, there must be some other characters in the string. This is necessary to test these very addresses, whether they are normally parsed by the application with all sorts of characters.

DBMS PostgreSQL

Answer 1

Regular expressions.
Something like https://www.postgresql.org/docs/9.3/functions-matc...