you are at Encyclopedia of SQL >> OR AND
AND & OR
There are used for compound queries.
AND - if all conditions are true there will be returned record
OR - if any of condition is true there will be returned record
Syntax
SELECT `column_name`
FROM `table_name`
WHERE `column_name1`='value1'
AND `column_name2`='value2'
Example for AND
Display records with name Michał and surname Nowak
| name | surname | age |
|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
query
SELECT *
FROM `people`
WHERE `name`='Michał'
AND `surname`='Nowak'
result
| name | surname | age |
|---|
| Michał | Nowak | 13 |
Example for OR
Display people whose forname is Paweł or surname is Nowak
| name | surname | age |
|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
query
SELECT *
FROM `people`
WHERE `name`='Paweł'
OR `surname`='Nowak'
result
| name | surname | age |
|---|
| Paweł | Kowalski | 3 |
| Michał | Nowak | 13 |
There can be mixed AND & OR in single query. In this case there will be helpful
use of parenthesis () .
Example for OR & AND
Display people with surname Nowak and with name Ola or Rafał
| name | surname | age |
|---|
| Paweł | Kowalski | 3 |
| Ola | Nowak | 7 |
| Rafał | Nowak | 10 |
| Michał | Nowak | 13 |
query
SELECT *
FROM `people`
WHERE (`name`='Ola' OR `name`=`Rafał`)
AND `surname`='Nowak'
result
| name | surname | age |
|---|
| Ola | Nowak | 7 |
| Rafał | Nowak | 10 |
[ wróć na górę strony ]
