Search in Laravel collection?

Question

Laravel

There is a feature table

$compares = Compare::where('gender','=',$user->attributes->gender)->get();

How can I find data from a collection without creating additional queries?

now I have like this, but I need to get rid of so many requests

$hair_color = Compare::where('value','=', $user->attributes->hair_color)->where('type','=', 3)->first();
        if ($hair_color){
            $appearances.=$hair_color->content.',';
        }
        $eye_color = Compare::where('value','=', $user->attributes->eye_color)->where('type','=', 4)->first();
        if ($eye_color){
            $appearances.=$eye_color->content.',';
        }
        $appearance = Compare::where('value','=', $user->attributes->appearance)->where('type','=', 5)->first();
        if ($appearance){
            $appearances.=$appearance->content.',';
        }
        $body_type = Compare::where('value','=', $user->attributes->body_type)->where('type','=', 6)->first();
        if ($body_type){
            $appearances.=$body_type->content.',';
        }

Answer 1

Open the documentation and read about the query builder.