Laravel Eloquent: Extract all entries that begin with a list of provided string

Question

The following request extract all entries from the users table where name=Albert or name=Alberto or name=Ana.

$users = DB::table('users')
    ->whereIn('name', ['Albert', 'Alberto', 'Ana'])
    ->get();

Is there is possibility to adapt this request to extract all entries that begin with the following names ?

Answer 1

Use the like operator on the basic where function:

$users = DB::table('users')
            ->where('name', 'like', 'T%')
            ->get();

Source

Edit: Based on this answer (but simplified), here is a simple closure that solves your question:

$queryStr = ['Albert', 'Alberto', 'Ana'];
$users = DB::Table('users')            
    ->where(function ($query) use ($queryStr) {
         foreach($queryStr as $q){
            $query->orwhere('name', 'like',  $q . '%');
         }      
    })->get();

Answer 2

Why not chaining orwhere clause:

$names = ['Albert', 'Alberto', 'Ana'];

$users = DB::table('users');

foreach ($names as $name) {
    $users->orWhere('name', 'like', $name.'%');
}

$users = $users->get();