The Percent Sign (%) Wildcard Character

Use the % wildcard character to represent any string of zero or more characters.

For example, to find all the phone numbers in the authors table that begin with the 415 area code:
select phone
from authors
where phone like "415%"
To find names that have the characters “en” in them (Bennet, Green, McBadden):
select au_lname 
from authors 
where au_lname like "%en%"

Trailing blanks following “%” in a like clause are truncated to a single trailing blank. For example, “%” followed by two spaces matches “X ”(one space); “X  ” (two spaces); “X   ” (three spaces), or any number of trailing spaces.