Error When using FIND_IN_SET in Laravel and PostgreSQL

Asked May 25 '22 at 07:20

Active May 25 '22 at 07:50

Viewed 237 times

Showing error when using FIND_IN_SET in Laravel and PostgreSQL

SQLSTATE[42883]: Undefined function: 7 ERROR: function find_in_set(uuid, character varying) does not exist LINE 1

$companyData = DB::table('companies')
                ->select('companies.*')
                ->leftjoin("industries",\DB::raw("FIND_IN_SET(industries.id,companies.indusrty_id)"),">",\DB::raw("'0'"))
                ->where('companies.id',$companyId)
                ->get();

Code After suggestion from comments

$companyData = DB::table('companies')
                ->select('companies.*')
                 ->join('industries', function($join)
                    {
                         $join->on('companies.indusrty_id', '=', 'industries.id')
                         ->where('industries.id', '=', any (string_to_array('companies.indusrty_id',',')));
                    })
                ->where('companies.id',$companyId)
                ->get();

now showing Call to undefined function App\Http\Controllers\any()

edited May 25 '22 at 07:50

asked May 25 '22 at 07:20

Satheesh Kumar

1

Does this answer your question? [Rails4 FIND\_IN\_SET with PG not working](https://stackoverflow.com/questions/32391486/rails4-find-in-set-with-pg-not-working) – brombeer May 25 '22 at 07:29
@brombeer any alternative for that . I am working with in Laravel and PostgreSQL – Satheesh Kumar May 25 '22 at 07:30
1

@SatheeshKumar: the alternative is in the accepted answer of brombeer's link – May 25 '22 at 07:35
@brombeer code updated – Satheesh Kumar May 25 '22 at 07:50
@a_horse_with_no_name code updated as per link given. – Satheesh Kumar May 25 '22 at 07:51
1

`any()` should most likely also be used in a `DB::raw(...)` call – brombeer May 25 '22 at 08:01

Error When using FIND_IN_SET in Laravel and PostgreSQL

0 Answers0