Laravel - Order by as Number (int), even if column type is string

Question

here it is:-

$query = Section::orderBy("section", "desc")->get();

section here is a column with type string yet it is having numbers in it where i want to order by those numbers thanks for your response

user_10573560 · Answer

$query = Section::orderByRaw('CONVERT(section, SIGNED) desc')->get();

user_853360 · Answer

First you should use proper data types while designing schema.

For your existing schema you can tweak your order by clause to type cast your value at runtime using orderByRaw method

->orderByRaw('section * 1 desc')

user_9042348 · Answer

$query->orderByRaw("section::int", "desc")->get();