What is SQL LIKE?
The SQL LIKE operator enables a comparison to a part of a string using the % wild card character.
Why Use SQL LIKE?
The SQL LIKE operator is a powerful way to check for matching strings. It is often used for interactive display of lists.
How To Use SQL LIKE
SQL LIKE is used as follows.
SQL LIKE Syntax
The <like_condition> supports the following patterns:
SQL LIKE Example
The following example lists rows from the branch table where branch_name begins with the leading characters 'San'.
Here are the contents of the table:
This SQL Statement with LIKE is executed:
Here is the result.