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.

Click http://www.w3resource.com/sql/wildcards-like-operator/wildcards-like-operator.php link to open resource.