Laravel Bind where in values on DB::select()

Question

获取id值为$client_ids

的客户端列表的查询$client_ids的值为:

array:25 [▼
0 => "PC00003"
1 => "PC00015"
2 => "PC00017"
]

DB::select(DB::raw("SELECT * FROM clients WHERE client_id IN (:client_ids)",
array('client_ids'=>$client_ids)
)
);

错误是:

SQLSTATE[HY000]: General error: 2031 (SQL: SELECT * FROM clients WHERE client_id IN (:client_ids))

Answer 1

这将为您工作。

$results = DB::table('clients')->whereIn('client_id', $client_ids)->get();