ILIKE_ESCAPE
ilike_escape(string, like_specifier, escape_character)
Section titled “ilike_escape(string, like_specifier, escape_character)”- string: VARCHAR
- like_specifier: VARCHAR
- escape_character: VARCHAR
Example
Section titled “Example”SELECT ilike_escape('A%c', 'a$%C', '$');