Laravel Order By String Length

Hello Dev,Hi Guys,
This detailed guide will cover laravel order by length. if you want to see an example of laravel order by string length then you are in the right place. We will use laravel order by field length. I explained simply about 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);
    }
}

Laravel Order By String Length

Do you like below Tutorials ?

New Articles

Blog Categories

Random Articles