Like operator
Like operator is used in where clause to search for a
specified pattern in a column.
Gets data from table where firstname start with “n”
select * from Employees
where FirstName like 'n%'
Gets data from table where firstname end with “e”
select * from Employees
where FirstName like '%e'
Gets data from the table where firstname containg the whole
word “au”
select * from Employees
where FirstName like '%au%'
retrieve
data like “a” is at 2nd posotion at starting.
select * from Employees
where
FirstName like '_a%'
