Like operator.

It is used with and_
means starts or ends with enything If we want to dispay name ends with jay
select name from employee where nam like ' jay ';
Ooutput: Name
------
Vijay
Ajay
Sanjay
sujay
_ is used with like for exact pattern matching
EX:select name from emp where name like'__jay';
Output: name
-----
vijay
sujay