Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Reference » SQL language elements » Search conditions

 

LIKE, REGEXP, and SIMILAR TO search conditions

The REGEXP, LIKE, and SIMILAR TO search conditions are similar in that they all attempt to match a pattern to a string. Also, all three attempt to match an entire string, not a substring within the string.

The basic syntax for all three search conditions is similar:

expression search-condition pattern
 LIKE, REGEXP, and SIMILAR TO: Differences in pattern definition
 LIKE, REGEXP, and SIMILAR TO: Differences in character comparisons
 See also

LIKE search condition
REGEXP search condition
SIMILAR TO search condition