S
S
sergey4kin2021-04-28 16:55:38
PostgreSQL
sergey4kin, 2021-04-28 16:55:38

How to use ILIKE to search for lines with hyphens?

In the database, the strings are contained in Utf8 with hyphens:

Client type:
normal

Where instead of "normal" there may be a different status. How to use ILIKE to search for lines with hyphens?

Space instead of wrapping the result does not give:
AND Comment.body NOT ILIKE '%Тип клиента: обычный%'

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
galaxy, 2021-04-28
@galaxy

AND Comment.body NOT ILIKE E'%Тип клиента:\nобычный%'

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question