Laravel where or condition with example

How to use laravel where or condition with example ?

Aman Jain,

Laravel eloquent provides multiple ways to build the query one the of the feature of laravel eloquent is creating dynamic query based on condition or complicated queries.In this article i will show you to build where or condition in laravel with example. I will show you multiple example to create where or query condition and also the complicated queries.

Here is the simple syntax to use the laravel where query

Syntax to use

orWhere('COLUMN_NAME', 'OPERATOR', 'VALUE')

//or
 
orWhere('COLUMN_NAME', 'VALUE'); // in this case operator always will be `=`

//or

orWhere('RAW_QUERY_USING_DB_FACADE')

//OR 

orWhereColumnName('VALUE');

SQL of above query will be

select * from `table` where `COLUMN_NAME` = 'VALUE'

As you can see i have written multiple way to use same method with different parameters. So lets begin with simple examples

Example 1 – Simple orWhere example

In this example i will show you simple where condition with two parameters

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
  
class ArticleController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $Article = Article::select("*")
                        ->where("title", 'test')->orWhere("status",1)
                        ->get();
      \\or
      DB::table('articles')->where("title","test")->orWhere("status",1)->get();

   }
}

Output will be 

select * from `articles` where `title` = 'test' or `status` = 1

Example 2 – Passing operator to orWhere

In this example we will use operator like greater then, less then, equals to, like etc.

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
  
class ArticleController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $Article = Article::select("*")
                        ->where("title", 'test')->orWhere("status",">=" ,1)
                        ->get();
      \\or
      DB::table('articles')->where("title","like","%test%")
      ->orWhere("status" , ">=" , 1)->get();

      
   }
}

Output

select * from `articles` where `title` = 'test' or `status` >= 1

Example 3 – Multiple where condition

In this example we will use operator like greater then, less then, equals to, like etc.

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
  
class ArticleController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
      $Article = Article::select("*")
                        ->orWhere(['title'=>"test","status"=>'1'])
                        ->get();
      //or 

      $Article = Article::select("*")
                        ->where("title","like" ,'test')
                        ->orWhere("status", 1)
                        ->orWhere("is_active", 1)
                        ->get();
      

   }
}

Output

select * from `articles` where `title` like 'test' or `status` = 1 or `is_active` = 1

Example 4 – Complicated Raw query in where

In this example we will use DB::raw to use complicated query in our laravel application. Sometimes we wanted to use aggregate function in laravel where so

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
use DB;
  
class ArticleController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
      $Article = Article::select("*")
                        ->where("status",1)
                        ->orWhere(DB::raw("concat(first_name,'', last_name )"),"test test2")
                         ->get();
   }
}

Output

select * from `articles` where `status` = 1 or concat(first_name,'', last_name ) = 'test test2'

Example 5 – Add brackets to or where condition

In this example we will use DB::raw to use complicated query in our laravel application. Sometimes we wanted to use aggregate function in laravel where so

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\User;
use DB;
  
class ArticleController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
      $Article = Article::select("*")
                        ->where("title","test")
                        ->orWhere(function($q){
                          return $q->where("status",1)->where('is_active',1);
                        })
                         ->get();
    //or 

      $Article = Article::select("*")
                        ->where("title","test")
                        ->where(function($q){
                          return $q->where("status",1)->orWhere('is_active',1);
                        })
                         ->get();

   }
}

Output

select * from `articles` where `title` = 'test test2' or (`status` = 1 and `is_active` = 1 ) 

#or

select * from `articles` where `title` = 'test test2' and (`status` = 1 or `is_active` = 1 )
Php Laravel

Related Posts