How to Use Distinct in the Laravel Query Model

11 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 Show the Old Values in Multiple Select Options in Laravel

In this lesson, we will see how to show the old values in multiple select options when editing in La...


How to Get the Old Value of the Select in Laravel

In this lesson, we will see how to get the old value of the select when editing in Laravel, this app...


How to Show the Old Value of the Input Field When Editing in Laravel

in this lesson, we will see how to show the old value of the input field when editing in Laravel, th...


How to Prevent the Loop Incrementing Operator from Resetting Back to 1 in the Next Pagination Pages in Laravel

In this lesson, we will see how to prevent the loop incrementing operator from resetting back to 1 i...


How to Logout a User from the Other Devices in Laravel 11

In this lesson, we will see how to logout a user from the other devices in Laravel 11, sometimes you...


How to Logout a User from the Current Device in Laravel 11

In this lesson, we will see how to logout a user from the current device in Laravel 11, sometimes yo...


How to Import Multiple Classes from a Single Namespace in Laravel

In this lesson, we will see how to import multiple classes from a single namespace in Laravel by add...


Laravel 11 Livewire CRUD Application Tutorial Part 2

In the second part of this tutorial, we will display all the tasks on the home page and later we wil...


Laravel 11 Livewire CRUD Application Tutorial Part 1

This tutorial will show us how to create a Laravel 11 Livewire CRUD application. The user can c...


How to Conditionally Include a Blade Template in Laravel

In this lesson, we will see how to conditionally include a blade template in Laravel.Sometimes,...