I have laravel eloquent example query:
DB::select('SELECT * FROM users u WHERE u.id IN :param', ['param' => [1, 2, 3]]);
But it doesn’t work.
How can I bind this array parameter to query.
In symfony I could use ->setParameter(‘param’, Connection::PARAM_INT_ARRAY);
But I dont see option do it the same in Laravel.
Regards.
>Solution :
otherway, You can use a string and a Mark selector insteade of param :
DB::select('SELECT * FROM users u WHERE u.id IN (?)', ['1, 2, 3']);