Laravel 8: Call to database function

Question

I'm using a Laravel 8 for website developement, and on the next part of code, I execute a query:

$assig = DB::table('table')
->where('table.column', '=', "oneValue")
->select('anfunctionOnDatabase(2,table.columDesc)')
->get();

but it no works.

How I need call to database function on laravel?

Thanks

if you want to use functions of the database then you should use raw db for laravel — Aqib Javed
– Aqib Javed, Commented Apr 4, 2022 at 9:27

Muammer Topcu · Accepted Answer · 2022-04-04 09:38:10Z

2

Use selectRaw()

like this;

$assig = DB::table('table')
    ->where('table.column', '=', "oneValue")
    ->selectRaw('anfunctionOnDatabase(2,table.columDesc)')
    ->get();

answered Apr 4, 2022 at 9:38

Muammer Topcu

425 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AlirezaAhmadi · Accepted Answer · 2022-04-04 10:08:46Z

1

Use : DB::raw :

$assig = DB::table('table')
->where('table.column', '=', "oneValue")
->select(DB::raw("anfunctionOnDatabase(2,table.columDesc)"))
->get();

answered Apr 4, 2022 at 10:08

AlirezaAhmadi

721 silver badge11 bronze badges