How to use both WhereIn and Where

Hi,

I am trying to chain whereIn and Where like this:

DB::table('pwbs')->whereIn('code', 'in', $codeArray)->where('project_id', '=', $id)->delete();

But it is not working.

Could anyone pls suggest me the right syntax to do it?

Best Answer

Level 48

DB::table('pwbs')->whereIn('code',  $codeArray)
    ->where('project_id', $id)
    ->delete();

The 'in' does not go there

The = is optional

1 like

Level 67

whereIn(field, [array of values for field])

2 likes

Please or to participate in this conversation.