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 ]