How to Filter Multiple Fields in Query?

Yes you can do this by using the where(function(){}) method as follows:

For Laravel 4.2

$consulta = Model::where(function($query) use($string, $numero, $outro) {

     if($string)
         $query->where('nome', "like", "%{$consulta}%");

     if($numero)
         $query->where('matricula', '=', $numero);

      if($outro)
         $query->where('outro', "like", "%{$outro}%"); 
})
->paginate(20);

or

$consulta = Model::where(function($query) {

         if(Input::has('consulta'))
             $consulta = Input::get('consulta'); 
             $query->where('nome', "like", "%{$consulta}%");

         if(Input::has('matricula'))
             $numero = Input::get('matricula');
             $query->where('matricula', '=', $numero);

          if(Input::has('outro'))
             $outro = Input::get('outro');
             $query->where('outro', "like", "%{$outro}%"); 
    })
   ->paginate(20);

for laravel 5.2

$consulta = Model::where(function($query) use($request) {

         if($request->has('consulta'))
             $consulta = $request->consulta; 
             $query->where('nome', "like", "%{$consulta}%");

         if($request->has('matricula'))
             $numero = $request->matricula;
             $query->where('matricula', '=', $numero);

          if($request->has('outro'))
             $outro = $request->outro;
             $query->where('outro', "like", "%{$outro}%"); 
    })
    ->paginate(20);

Petter, if the query logic is going to repeat, it does not have to fill the "stop" of if . I recommend you simplify your code by encapsulating query logic within a loop.

You would not have to make multiple ifs , but you could do a foreach and apply the logic in there.

$callback = function ($query) use($request) {

    $likes = ['primeiro_nome', 'email', 'sobrenome'];

    foreach ($request->only($campos_like) as $name => $value)
    {
        $value && $query->where($name, 'LIKE', "%{$value}%");
    }


    $equals = ['nivel_id', 'idade', 'curso'];

    foreach ($request->only($campos_equal) as $name => $value) {

        $value && $query->where([$name => $value]);
    }

};

Usuario::orderBy('primeiro_nome')->where($calback)->paginate(15)->appends($request->all());

Note that it is not necessary to fill the code with if . If you can simplify, always simplify.

Maybe you're wondering, "But where are the ifs?"

If you look closely, I replaced if with expression $value && $query->where(...) . I usually do this when I want to simplify a if . But I will not go into many details, as I have answered this before:)

Refactoring is worth it if the soul is not small!