LIKE is used for pattern comparison
LIKE is designed to work with character data
List of employees whose names begin with A
SELECT name FROM employees WHERE name LIKE 'A%'
LIKE is accompanied by two wildcard characters: the percentage symbol (%) and underscore character (_)
The percentage symbol (%) denotes one or more characters.
The underscore character (_) denotes one character.