In a WHERE clause, the LIKE operator is used to look for a certain pattern in a column. When combined with the LIKE operator, the following two wildcards are frequently used: Zero, one, or more characters can be represented by the percent symbol (%). The underscore (_) symbol designates a single character.