Hi 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 and laravel 10 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:

<?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);
    }
}	

<?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...