How to Use Distinct in the Laravel Query Model

9 months ago admin Laravel

In this lesson, we will see how to use distinct in the Laravel query model, so let's assume that we have a table where we store image extensions and we want to get all the extensions and eliminate all duplicate records from the result.


Use distinct in the Laravel query model

So, to get all extensions from the table and eliminate all duplicate records from the result use the following code.

                                                    
                                                                                                                
    /**
     * Fetch all the extensions
    */
    public function fetchExtensions()
    {
        $extensions = Image::select('ext')->distinct()->get();
        return redirect()->route('home')->with([
            'extensions' => $extensions
        ]);
    }

Related Tuorials

How to the Get the Previous and Next Posts in Laravel

In this lesson, we will see how to get the previous and next posts in Laravel, sometimes when you ge...


How Do you Format a Number as K/M/B in Laravel

In this lesson, we will see how to format a number as K/M/B in Laravel, sometimes we want to display...


How to Override Laravel Fortify Default Registration Redirect

In this lesson, we will see how to override Laravel Fortify default registration redirect, sometimes...


How to Override Laravel Fortify Default Login Redirect

In this lesson, we will see how to override Laravel Fortify default login redirect, sometimes when w...


How to Use the Same Validation Form Request for both Create and Update in Laravel

In this lesson, we will see how to use the same validation form request for both create and update i...


How to Get Raw SQL Output from the Eloquent Model in Laravel 11

In this lesson, we will see how to get raw SQL output from the eloquent model in Laravel 11, sometim...


How to Check if a Record Does Not Exist in Laravel

in this lesson, we will see how to check if a record does not exist in laravel, sometimes you need t...


How to Check if a Record Exists in Laravel

in this lesson, we will see how to check if a record exists in laravel, sometimes you need to check...


How to Decrement Multiple Fields in Laravel

In this lesson, we will see how to decrement multiple fields in Laravel, in the old versions of lara...


How to Increment Multiple Fields in Laravel

In this lesson, we will see how to increment multiple fields in Laravel, in the old versions of lara...