SQL LIKE #

LIKE combined with the WHERE clause enables pattern matching.

Construct #

Something like this:

SELECT ...
FROM ...
WHERE <column> LIKE `<string>`;

Wildcards #

_ within a like string serves as a placeholder for any character.

% matches zero or more missing characters. %A would match A as the last character, A% would match A as the first character, %A% would match A anywhere in the string.