expr NOT LIKE pat [ESCAPE 'escape_char']

expr NOT LIKE pat [ESCAPE 'escape_char']

Syntax

MYSQL Copy

CREATE TABLE foo (bar VARCHAR(10));

INSERT INTO foo VALUES (NULL), (NULL);

Examples

Example

This is the same as NOT (expr LIKE pat [ESCAPE 'escape_char']).

MYSQL Copy

CREATE TABLE foo (bar VARCHAR(10));

INSERT INTO foo VALUES (NULL), (NULL);

Example 2

Aggregate queries involving NOT LIKE comparisons with columns containing NULL may yield unexpected results. For example, consider the following table and data:

MYSQL Copy

SELECT COUNT(*) FROM foo WHERE bar NOT LIKE '%baz%' OR bar IS NULL;