Summer Sale! All accounts are 50% off this week.

satheeshkumarj's avatar

PostgreSQL comma separated column join in PHP Laravel

How to write join query for PostgreSQL comma separated column join in PHP Laravel. FIND_IN_SET() will not works as I am using PostgreSQL Industry Table

id | name
1   | int1
2   | int2
3   | int3

Company Table

id | name | industry_id
1    | cmp1 | 1, 2
2   | cmp2 | 1
3   | cmp3 | 1, 2, 3

Need to join company table with industry table

0 likes
0 replies

Please or to participate in this conversation.