The SQL LIKE operator is only used on CHAR or VARCHAR fields to match a pattern. LIKE operator can be used to match a pattern from a word, special characters, and wildcard characters. Any acceptable SQL statement, such as SELECT, INSERT INTO, UPDATE, or DELETE, can contain the LIKE operator.