MySQL LIKE

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.