•    The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.
•    When using the LIKE operator, two common wildcards are the percent sign (%) which represents zero, one, or multiple characters, and the underscore sign ( _) which represents a single character.

          SELECT column1, column2, . . .

          FROM table_name

          WHERE columnN LIKE pattern;