How to Use Laravel 10 Eloquent Order By Length Query?

May 02, 2023 . Admin



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:

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

#Laravel 10