you are at Encyclopedia of SQL >> IN
IN
IN is used after WHERE and it gives opportunity to choose values in specified
column which will be displayed as a result of query.
Syntax
SELECT `column_name` FROM table_name`
WHERE `column_name`
IN ('value1','value2')
Example
Display name and surname of people with surname Kowalski or Nowak
| name | surname | age |
|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
query
SELECT `name`,`surname`
FROM `people`
WHERE `surname`
IN ('Kowalski','Nowak')
result
| name | surname | age |
|---|
| Paweł | Kowalski | 3 |
| Michał | Nowak | 13 |
[ wróć na górę strony ]
