Write an SQL query to find names of employee start with 'A'?

Last updated 3 years, 8 months ago | 2049 views 75     5

Tags:- SQL MySQL

SQL | LIKE operator

The LIKE operator of SQL is used for such kind of operations. It is used to fetch filtered data by searching for a particular pattern in where clause.


The Syntax for using LIKE is,

SELECT column1, column2, ...
FROM table_name
WHERE columnN LIKE pattern;

The required query is:

SELECT * FROM employees WHERE empName like 'A%' ;