LIKE Operator

Purpose: Searches for a specified pattern in a column.Syntax:

column_name LIKE pattern

Example:

SELECT * FROM employees WHERE first_name LIKE 'A%';

Explanation: This retrieves employees whose first names start with “A”. The % wildcard represents zero or more characters.