'Laravel 8: Call to database function

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



Solution 1:[1]

Use selectRaw()

like this;

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

Solution 2:[2]

Use : DB::raw :

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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Muammer Top
Solution 2 AlirezaAhmadi