Bind array param in raw query with WHERE IN/WHERE NOT IN

Question

How can I properly bind an array for a raw query's NOT IN / IN?

The following throws an array to string conversion error:

    $user_list_to_exclude = [1, 2, 3];
    
    $data = DB::select("SELECT * FROM users WHERE user_id NOT IN :user_list_to_exclude",
                ['user_list_to_exclude' => $user_list_to_exclude]);

Does this answer your question? How to bind parameters to a raw DB query in Laravel that's used on a model? — Omi Shah
– Omi Shah, Commented Jul 19, 2023 at 8:49
My bindings are working but not for an array. The other posts use a single value bindings (Which work for me) — pileup
– pileup, Commented Jul 19, 2023 at 8:55

Hans Zhang · Accepted Answer · 2024-07-04 04:26:09Z

1

You cannot in an easy way since Laravel is just using PHP's builtin bindValue method: https://www.php.net/manual/en/pdostatement.bindvalue.php

See:

You have to bind the values individually with named/placed parameters.

answered Jul 4, 2024 at 4:26

Hans Zhang

5095 silver badges6 bronze badges

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

Collectives™ on Stack Overflow

Bind array param in raw query with WHERE IN/WHERE NOT IN

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related