How to retrieve records ordered by a specific column using Eloquent in Laravel?

To retrieve records ordered by a specific column using Eloquent in Laravel, you can use the orderBy method on the query builder.

Here is an example of how to retrieve records ordered by a specific column:

$records = YourModel::orderBy('column_name', 'asc')->get();

In the above example, replace YourModel with the actual name of your Eloquent model, and column_name with the name of the column you want to order by. The second argument to the orderBy method indicates the sorting direction, where 'asc' represents ascending order, and 'desc' represents descending order.

You can also chain multiple orderBy methods to sort by multiple columns:

$records = YourModel::orderBy('column1', 'asc')
                    ->orderBy('column2', 'desc')
                    ->get();

In this example, the records will be sorted by column1 in ascending order, and then column2 in descending order.

Additionally, if you only want to retrieve a single record, you can use the first method instead of get:

$record = YourModel::orderBy('column_name', 'desc')->first();

This will retrieve the first record in the ordering specified by the orderBy method.