I am trying to get search results where atleast 2 or 3 keywords match in keywords array.

Example Table

            $categories = explode(',' ,$site->category);
            $keywords = explode(',' ,$site->keywords);
            
            foreach( $categories as $category)
            {
            $results = Website::where('category', 'like',"%{$category}%")
            ->where('name', '!=', $name)  
            ->where(function ($query) use ($keywords){
                
    
                foreach( $keywords as $keyword)
                {
                    $query->orWhere('keywords','like', "%{$keyword}%");
                }
    
            }             
            )   

Above codes returns all results that match single keyword, **Requirement **: Only results that match more than 2 keywords. How can I achieve this?

CodePudding user response：

Try to use where-subquery. Something like this:

Website::where('category', 'like',"%{$category}%")
    ->where('name', '!=', $name)
    ->where(function ($query) {
        $query->selectRaw('count(websites.keywords)')
            ->from('websites')
            ->where('keywords', 'like', "%{$keyword}%")
    }, '>', 2)
    ->get();