[Casimiro Noteví]

Exactamente así:

LIKE is a case-sensitive pattern search operator. It is quite a blunt instrument
compared to pattern searches in regular expression engines. It recognizes two “wild-
card” symbols, % and _ (the underscore character), that work as follows:
• % can be substituted into a search string to represent any number of unknown
characters, including none, for example:
LIKE '%mit%'
will be true with strings such as 'blacksmith', 'mitgenommen', 'commit', as well
as 'mit'.
• An underscore character ( _ ) can be substituted into a search string to represent
a single, unknown character. For example, the following searches for records
where the surname might be 'Smith', 'Smyth', or a similar pattern:
LIKE 'Sm_th'