More than 5 years have passed since last update.

LaravelのorWhere

DB
Laravel
orWhere

Posted at 2018-01-11

DB::table('users')
            ->where('name', '=', 'John')
            ->orWhere(function ($query) {
                $query->where('votes', '>', 100)
                      ->where('title', '<>', 'Admin');
            })
            ->get();

select * from users where name = 'John' or (votes > 100 and title <> 'Admin')

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up