Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Laravel query builder where and or where

I want to build a query something like this:

select * from users where id=1 AND address="USA" AND (status="active" OR status="pending")

how can i do that with laravel query builder?

please help. Thanks!

like image 842
JSN Avatar asked Jul 27 '17 19:07

JSN


1 Answers

Try to find complex query examples with Laravel Query Builder. And maybe this can help a little:

DB::table('users')
    ->where('id', 1)
    ->where('address', 'USA')
    ->where(function($query) {
        $query->where('status', 'active')
            ->orWhere('status', 'pending');
    })->get();

or:

DB::table('users')
    ->where([
        ['id', 1],
        ['address', 'USA'],
    ])
    ->where(function($query) {
        $query->where('status', 'active')
            ->orWhere('status', 'pending');
    })->get();
like image 118
blues911 Avatar answered Oct 22 '22 06:10

blues911