LIKE operator in Sql

The SQL LIKE clause is used to match a value to a similar values using wildcard operators. It is used with Where Clause.

There are two type of wildcards used in conjunction with the LIKE operator.

The percent sign (%) that is  used to represent zero , one, or multiple characters.
The underscore (_) that is used to represent a single number or character.