📄️ like
Pattern matching using an SQL pattern. Returns 1 (TRUE) or 0 (FALSE). If either expr or pat is NULL, the result is NULL.
Comparisons Functions
📄️ not like
Pattern not matching using an SQL pattern. Returns 1 (TRUE) or 0 (FALSE). If either expr or pat is NULL, the result is NULL.
📄️ not regexp
Returns 1 if the string expr doesn't match the regular expression specified by the pattern pat, 0 otherwise.
📄️ not rlike
Returns 1 if the string expr doesn't match the regular expression specified by the pattern pat, 0 otherwise.
📄️ regexp
Returns 1 if the string expr matches the regular expression specified by the pattern pat, 0 otherwise.
📄️ rlike
Returns 1 if the string expr matches the regular expression specified by the pattern pat, 0 otherwise.
📄️ symbol comparisons
Examples