How to write join query for PostgreSQL comma separated column join in PHP Laravel. `FIND_IN_SET()` will not work as I am using PostgreSQL:

[![enter image description here](https://i.stack.imgur.com/rur5R.png)](https://i.stack.imgur.com/rur5R.png)

I need to join `Industry` table with `Company` table. While company can have multiple industries they are entered in `industry_id` column and values are separated by comma.

`FIND_IN_SET()` will not work as I am using PostgreSQL

Mysql query:

```
$companyData = "SELECT comp.* 
                FROM companies AS comp 
                LEFT JOIN `industries` as `indus` ON find_in_set(indus.id, comp.indusrty_id) > 0           
                WHERE comp.id = ".$companyId;

```