OrWhere and advanced conditions in Laravel

Introduction

OrWhere helps you add extra choices to your database search. It lets you say, "Find this OR that." Advanced conditions let you build smart, detailed searches.

You want to find users who live in city A OR city B.

You need to get products that are either on sale OR have free shipping.

You want to search posts that are either published OR created by a specific user.

You want to combine many conditions with both AND and OR to get precise results.

Syntax

Laravel

DB::table('table_name')
  ->where('column1', 'value1')
  ->orWhere('column2', 'value2')
  ->get();

orWhere adds an OR condition after a where condition.

You can pass a closure (function) to group conditions inside orWhere for complex queries.

Examples

Find users who are active OR have the admin role.

Laravel

DB::table('users')
  ->where('status', 'active')
  ->orWhere('role', 'admin')
  ->get();

Find products cheaper than 100 OR products with stock over 50 AND a discount.

Laravel

DB::table('products')
  ->where('price', '<', 100)
  ->orWhere(function($query) {
      $query->where('stock', '>', 50)
            ->where('discount', '>', 0);
  })
  ->get();

Find posts that are published OR written by author with ID 5.

Laravel

DB::table('posts')
  ->where('published', true)
  ->orWhere('author_id', 5)
  ->get();

Sample Program

This code finds users older than 30 OR users who are admins and active. It prints their name, age, role, and if they are active.

Laravel

<?php
use Illuminate\Support\Facades\DB;

$results = DB::table('users')
    ->where('age', '>', 30)
    ->orWhere(function($query) {
        $query->where('role', 'admin')
              ->where('active', true);
    })
    ->get();

foreach ($results as $user) {
    echo "User: {$user->name}, Age: {$user->age}, Role: {$user->role}, Active: " . ($user->active ? 'Yes' : 'No') . "\n";
}

Important Notes

Use closures inside orWhere to group multiple conditions together.

orWhere always adds an OR condition, so be careful with logic order.

Test your queries in Laravel Tinker or database tools to see results clearly.

Summary

orWhere adds OR conditions to your database queries.

Use closures to create complex grouped conditions inside orWhere.

Combining where and orWhere helps build flexible and powerful searches.