LIKE

It is used in the conditional part of a query. It replaces the „=“ operator. It is used when you want to use filtering with an undefined beginning/end of a string.

%     defines zero, one to an indefinite number of characters
_      defines exactly one character

Structure:

SELECT column_name
FROM table_name
WHERE column_name LIKE pattern;

 

Example1:

We have a table Customer with this data:

 

SELECT name
FROM Customer
WHERE name LIKE 'T%';

 

Example2:

SELECT name
FROM Customer
WHERE name LIKE '%a';

 

Example3:

SELECT name
FROM Customer
WHERE name NOT LIKE '%a%';

 

Example4:

SELECT name
FROM Customer
WHERE name LIKE '%o%';

 

Example5:

SELECT name
FROM Customer
WHERE name LIKE '__or';