The LIKE operator allows comparison with a pattern of characters. A pattern contains special characters which match a single character(_), or zero or more characters(%).
Suppose we want to track down all employees with an 'A' as the second letter of their name (don't ask why you would want to do this!).
SELECT * FROM emp WHERE ename LIKE '_A%';