Using a LIKE condition without a wildcard (% or _) is suspicious. A maintainer can suppose whether a wildcard is forgotten or it is meant as equality test.
if (last_name like 'Smith') ...
if (last_name like 'Smith%') ... -- or if (last_name = 'Smith') ...