The underscore (_) wildcard character

Use the underscore ( _ ) wildcard character to represent any single character. For example, to find all six-letter names that end with “heryl” (for example, Cheryl):

select au_fname 
from authors 
where au_fname like "_heryl"