Make Laravel Model::whereIn case-sensitive

We have this code.

$users = UserCode::whereIn('code', $codeList)->get();


The issue with this code is, it is case insensitive. We want to the code to be case-sensitive.

We tried something like:

$users = UserCode::whereIn(DB::raw('BINARY `code`'), $codeList)->get();


but this only returns the first and not of the list.

Any help would be appreciated.

Continue reading...