Like Operator

Like Operator in SQL

Like Operator is used in a WHERE clause to search for a specified pattern in a column. Suppose you want to search those employee record whose name start with H alphabet.

SELECT column_name
FROM table_name
WHERE column_name LIKE pattern;

Employee table

SELECT * from Employee
WHERE name LIKE 'H%';

Result after using Like Operator.