Laravel order by field length

Question

I want to build a query that order data by certain field length. I need to rewrite this query to laravel's Eloquent ORM.

SELECT * FROM table ORDER BY CHAR_LENGTH(field)

Answer 1

It seems that orderByRaw is what you're looking for. Here's an example:

User::orderByRaw('CHAR_LENGTH(name)')->get();