PostgreSQL Where
The PostgreSQL WHERE clause is used to return records that meet the conditions in a select.
Where syntax
-- select the records that meet the condition
SELECT * FROM table_name WHERE {condition}
SELECT * FROM view_name WHERE {condition}
SELECT * FROM A, B WHERE A.id=B.id
Where example
Goods table
| id |
good_type |
name |
description |
price |
insert_date |
| 1 |
A |
Car_1 |
Car 1 description |
100 |
2018-07-21 08:45:57.311809 |
| 2 |
A |
Car_2 |
Car 2 description |
200 |
2018-07-21 08:45:57.311809 |
| 3 |
A |
Car_3 |
Car 3 description |
100 |
2018-07-21 08:45:57.311809 |
| 4 |
B |
Boat_4 |
Boat 4 description |
500 |
2018-07-21 08:45:57.311809 |
| 5 |
B |
Boat_5 |
Boat 5 description |
300 |
2018-07-21 08:45:57.311809 |
| 6 |
C |
Train_1 |
Train 123 description |
800 |
2018-07-21 08:45:57.311809 |
SELECT * FROM goods WHERE price = 100;
Result
| id |
good_type |
name |
description |
price |
insert_date |
| 1 |
A |
Car_1 |
Car 1 description |
100 |
2018-07-21 08:45:57.311809 |
| 3 |
A |
Car_3 |
Car 3 description |
100 |
2018-07-21 08:45:57.311809 |