Select * from where like ‘%RAJESH%’ escape ‘\’;
LIKE operator is used for pattern matching
_ stands for one character
% stands for muliple charcter
ESCAPE used for find _ or % in the string then you need to use escape clause
Search for middle name sharma in your employee table
select * from employee where employee_name like ‘%SHARMA%’ ;
Search for first character not know:
Select * from employee where employee_name like ‘_SHARMA’
It will give you result like ASHARMA and KSHARMA It will check only for first character.
If you data having _ in the value of that column suppose email id column having _ as data
select * from employee where email_id like ‘%\_sharma%’ escape ‘\’;
It will take _ as data due to escape clause used in it.