How To Use LIKE Conditions? | MySQL Interview Questions

A LIKE condition is also called pattern patch. There are 3 main rules on using LIKE condition:
=> is used in the pattern to match any one character.
=> % is used in the pattern to match any zero or more characters.
=> ESCAPE clause is used to provide the escape character in the pattern.