The Underscore (_) Wildcard 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"