LIKE

Syntax:
expr LIKE pat [ESCAPE 'escape_char']

Pattern matching using an SQL pattern. Returns 1 (TRUE) or 0 (FALSE).
If either expr or pat is NULL, the result is NULL.

The pattern need not be a literal string. For example, it can be
specified as a string expression or table column. In the latter case,
the column must be defined as one of the MySQL string types (see
https://dev.mysql.com/doc/refman/8.0/en/string-types.html).

URL: https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html