Laravel Eloquent Where Not Equal To Condition Example

Posted by

Hello Laravel Developers,


In this post, we will explore how to use the Laravel Eloquent framework to apply a “not equal to” condition in your database queries. This example will demonstrate how to utilize Laravel’s Eloquent to filter records where a specific column does not have a certain value.

In Laravel’s Eloquent, the where method is a powerful tool for adding conditions to your database queries. One common use case is when you want to retrieve records where a particular column is not equal to a specific value. You can achieve this by using either the ‘!=‘operator or the ‘<>‘ operator. Let’s delve into how to use both of these operators:

Let’s say you have a “users” table, and you want to fetch all users whose “status” column does not equal a specific value, such as “0”. Here’s a representation of a simple table with sample data:

users Table:

Laravel Where Not Equal To using “!=” Operator:

the simple code of UserController File.

<?php

     

namespace App\Http\Controllers;

    

use Illuminate\Http\Request;

use App\Models\User;

    

class UserController extends Controller

{

    /**

     * Display a listing of the resource.

     *

     * @return \Illuminate\Http\Response

     */

    public function index(Request $request)

    {

        $users = User::select("id", "name", "email", "status")

                    ->where('status', '!=', '0')

                    ->get();

  

        dd($users);

    }

}

Output:-

Array

(

    [0] => Array

        (

            [id] => 1

            [name] => Admin User

            [email] => admin@cotocus.com

            [status] => 1

        )

    [1] => Array

        (

            [id] => 2

            [name] => Manager User

            [email] => manager@cotocus.com

            [status] => 1

        )

)

Laravel Where Not Equal To using “<>” Operator:

the simple code of UserController File.

<?php

     

namespace App\Http\Controllers;

    

use Illuminate\Http\Request;

use App\Models\User;

    

class UserController extends Controller

{

    /**

     * Display a listing of the resource.

     *

     * @return \Illuminate\Http\Response

     */

    public function index(Request $request)

    {

        $users = User::select("id", "name", "email", "status")

                    ->where('status', '<>', '0')

                    ->get();

  

        dd($users);

    }

}

Output:

Array

(

    [0] => Array

        (

            [id] => 1

            [name] => Admin User

            [email] => admin@cotocus.com

            [status] => 1

        )

    [1] => Array

        (

            [id] => 2

            [name] => Manager User

            [email] => manager@cotocus.com

            [status] => 1

        )

)

I hope it can help you!!!!!

Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x