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

Last updated 4 years, 11 months ago | 2540 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%' ;