It is used with the like operator to compare the values of the type similar.
It support two wildcards type
1. The percent sign (%)- It match to one or more character.
2. The underscore (_)- It match to one character.
<-- Chapter 9: SQL != Operator
SQL LIKE Operator
Lets see an example from the below table "employees" :-