Home
PostgreSQL Like

PostgreSQL Like

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