w3resource: "SQL LIKE Operator"

LIKE is typically used to find all records that have a column value that matches a specific pattern. Special characters are used to specify the format of the pattern.