[PostgreSQL Like Operator]How PostgreSQL stores LIKE and ILIKE #PSQL

psq-like-operators.md

In PostgreSQL the LIKE operators are stored as "double tilde" binary operators:

• LIKE: ~~
• ILIKE: ~~*
• NOT LIKE:!~~ and
• NOT ILIKE: !~~*

All of these operators are PostgreSQL-specific

Source: https://stackoverflow.com/a/21926044 See also: http://www.postgresql.org/docs/current/interactive/functions-matching.html#FUNCTIONS-LIKE