Day: September 17, 2017

LIKE Operator
We can filter character string data based on pattern matching using LIKE operator.
We can use LIKE operator in where clause of select, delete and update statement.
Syntax:
select column1, column2,….,columnN
from table_name
where column LIKE pattern;
The wildcards used in LIKE patterns are:
Wildcard
Meaning
Example
%(percent)
Any string including an empty one
‘Kp%’