DML-select-Like:

nThe LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

Syntax:

SELECT column_name(s) FROM table_name

WHERE column_name LIKE pattern

Query:

üSELECT * FROM Emptbl WHERE EMPname LIKE ‘B%‘

üSELECT * FROM Emptbl WHERE EMPname LIKE '%a'

üSELECT * FROM Emptbl WHERE EMPname LIKE '%lli%‘

üSELECT * FROM Emptbl WHERE EMPname NOT LIKE '%lli%'