you are at Encyclopedia of SQL >> LIKE
LIKE
LIKE is used after WHERE keyword to choose record which columns mathes certain patern.
Syntax
SELECT `column_name`
FROM `table_name`
WHERE `column_name`
LIKE pattern
Example 1
Display name and surname of people which surname ends with letter k
| name | surname | wiek |
|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
query
SELECT `name`,`surname`
FROM `people`
WHERE `surname`
LIKE '%k'
result
| name | surname |
|---|
| Piotr | Janik |
| Michał | Nowak |
Example 2
Display name and surname of people which surname consists of "ani" syllable
| name | surname | age |
|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
query
SELECT `name`,`surname` FROM `people` WHERE `surname`
LIKE '%ani%'
result
[ wróć na górę strony ]
