LIKE
Pattern-matching conditions
Last updated
Pattern-matching conditions
Last updated
The LIKE operator compares a string expression, such as a column name, with a pattern that uses the wildcard characters % (percent) and _ (underscore). LIKE pattern matching always covers the entire string. To match a sequence anywhere within a string, the pattern must start and end with a percent sign. ().
This grammar is fully supported in .
Output Code:
Output Code:
Output Code:
Output Code:
The following operators are translated as follows:
~~
LIKE
!~~
NOT LIKE
~~*
ILIKE
!~~*
NOT ILIKE
Output Code:
There are no known issues.
The behavior of fixed char types may differ. Click for more information.