how is like operator implemented in sql code example

Example: like operator in sql

(Like) Operator for partial searches using wildcard '%' and '_'
For Example:
Select * From Employees
Where last_name LIKE '_a%';