Laravel Eloquent Order By Length Query Example

Hello Dev,

I am going to show you an example of laravel order by length. We will look at an example of laravel order by string length. you'll learn laravel order by field length. you will learn laravel eloquent length(). Follow the below tutorial step of laravel eloquent length order by.

You can use this example with laravel 6, laravel 7, laravel 8, laravel 9, laravel 10 and laravel 11 versions.

If you want to get data in order by field length in Laravel. Then laravel eloquent provides orderByRaw() function to use CHAR_LENGTH() mysql function.

so, let's see the below example code:

Example 1: Laravel Order By Field Length ASC

<?php
   
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\Models\Post;
  
class PostController extends Controller
{
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function index(Request $request)
    {
        $posts = Post::select("id", "title")
                        ->orderByraw('CHAR_LENGTH(title) ASC')
                        ->get();
 
        dd($posts);
    }
}

Example 2: Laravel Order By Field Length DESC

<?php
   
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\Models\Post;
  
class PostController extends Controller
{
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function index(Request $request)
    {
        $posts = Post::select("id", "title")
                        ->orderByraw('CHAR_LENGTH(title) DESC')
                        ->get();
 
        dd($posts);
    }
}

I hope it can help you...