The SQL Like is a logical operator that is used to determine whether a specific character string matches a specified pattern. It is commonly used in a Where clause to search for a specified pattern in a column. This operator can be useful in cases when we need to perform pattern matching instead of equal or not equal.

The SQL LIKE Operator
The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are two wildcards often used in conjunction with the LIKE operator:

% - The percent sign represents zero, one, or multiple characters
_ - The underscore represents a single character

The percent sign and the underscore can also be used in combinations!

LIKE Syntax is given as follows:

SELECT column1, column2, column2, ...FROM table_name WHERE columnN LIKE pattern;

SQL LIKE Examples is given as follows:
The following SQL statement selects all admins with an AdminName starting with "c":

Example

SELECT * FROM SlightBook WHERE AdminName LIKE 'c%';

The following SQL statement selects all admins with an AdminName ending with "c":

Example

SELECT * FROM SlightBook WHERE AdminName LIKE '%c';