MySQL LIKE
Last Updated: March 12, 2022
MySQL 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.