LIKE, NOT LIKE

The LIKE and NOT LIKE operators are useful for matching patterns containing simple wildcards.

The % character appearing in a pattern matches any string and the _ character matches a single character. For example:

CREATE TABLE like_s (b int, t varchar(20));
INSERT INTO like_s VALUES(0, 'red'), (1, 'blue');

SELECT * FROM like_s WHERE t LIKE 'r_d';
****
+------+------+
| b    | t    |
+------+------+
|    0 | red  |
+------+------+

SELECT * FROM like_s WHERE t NOT LIKE 'r%';
****
+------+------+
| b    | t    |
+------+------+
|    1 | blue |
+------+------+

You can use the backslash character \ as an escape character with a LIKE operator so that SingleStoreDB Cloud interprets the wildcard character as a literal character. For example:

SELECT "foo_" LIKE "foo\_";
****
+---------------------+
| "foo_" LIKE "foo\_" |
+---------------------+
|                   1 |
+---------------------+