How to write SQL function eloquent in Laravel?

Question

I have a query like is

MODEL::Where(...)
->whereRaw(...)
->get()

I want to add my SQL function before ->get().

Here, I want to add this raw:

AND functionX(Id, 1) IN ('1','2','3');

I try to whereRaw but it does not work. Any ideas?

https://stackoverflow.com/questions/22758819/laravel-wherein-or-wherein see this — Paras Raiyani, Jun 02 '22 at 10:43
whereIN only works a table I need to run function. How can you write functionX whereIn claus? — , Jun 02 '22 at 10:43
DB::table('users') ->select(DB::raw('count(*) as user_count, status')) ->where('status', '<>', 1) ->groupBy('status') ->get(); try it like this — Saravana Sai, Jun 02 '22 at 10:48

Abdo Arj · Answer 1 · 2022-06-02T10:58:22.313

0

You can use DB::raw.
For Example :

MODEL::Where(...)->where(DB::raw("functionX(Id, 1) IN ('1','2','3')")->get()

edited Jun 02 '22 at 10:58

answered Jun 02 '22 at 10:55

Abdo Arj

1 Answers1