PostgreSQL Like
The PostgreSQL LIKE is used to return rows if the operand matches a pattern in a select.
Like syntax
SELECT * FROM table_name WHERE column_name LIKE pattern;
Like 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 name LIKE '%Boat%';
Result
| id | good_type | name | description | price | insert_date |
|---|---|---|---|---|---|
| 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 |
select * from goods where name LIKE 'Tra%';
Result
| id | good_type | name | description | price | insert_date |
|---|---|---|---|---|---|
| 6 | C | Train_1 | Train 123 description | 800 | 2018-07-21 08:45:57.311809 |
select * from goods where good_type LIKE 'C';
Result
| id | good_type | name | description | price | insert_date |
|---|---|---|---|---|---|
| 6 | C | Train_1 | Train 123 description | 800 | 2018-07-21 08:45:57.311809 |