Laravel Eloquent - How to group conditions

Question

I'm using the following eloquent statement

Title::where('word', 'lovers')
    ->orWhere('word', 'lover')
    ->where('domain', $resultFromFirstKeyword->domain)
    ->get();

Which I can see through the SQL logger produces the following SQL

SELECT * FROM `title` 
WHERE `word` = 'lovers' 
OR `word` = 'lover' 
AND `domain` = 'www.texasbirdlovers.com'

However the SQL that I would like to produce is

SELECT * FROM `title` 
WHERE (`word` = 'lovers' OR `word` = 'lover') 
AND `domain` = 'www.texasbirdlovers.com'

How would I achieve this?

Answer 1

This should work:

Title::whereIn('word', ['lovers', 'lover'])
    ->where('domain', $resultFromFirstKeyword->domain)
    ->get();

If, however, you want to combine them exactly like you said, try this:

Title::where(function($query) {
        $query->where('word', 'lovers')
            ->orWhere('word', 'lover');
    })
    ->where('domain', $resultFromFirstKeyword->domain)
    ->get();

Answer 2

Just group your query in a where clause

Title::where(function($q){
         $q->where('word', 'lovers')->orWhere('word', 'lover');
 })->where('domain', $resultFromFirstKeyword->domain)->get();

Answer 3

Try

Title::where('domain', $resultFromFirstKeyword->domain)
    ->where(function($query) {
        return $query
            ->where('word', '=', 'lovers')
            ->orWhere('word', '=', 'word');
    })->get();

Answer 4

Try the following:

Title::where(function($query) {
    return $query
        ->where('word', 'lover')
        ->orWhere('word', 'lovers');
})
->where('domain', $resultFromFirstKeyword->domain)
->get();