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