Ordering number result with alphabet order.

It's because your name attribute in your table is of the var_char

which contains all letters and numbers so it looks at the first character in each string and sorts it

Solution: make it an integer

Off Topic: why not have both a number and a name attribute?

You can try alphanumeric sorting.

$pizzas = DB::table('pizzas')->orderBy('LENGTH(name)', 'ASC')
    ->orderBy('name', 'ASC')
    ->get();

Ref: http://stackoverflow.com/questions/26493608/laravel-php-order-by-alphabetical-with-numbers-in-order

@WebKenth :

i use integer in table.

$table->integer('name')->unique();

@tisuchi :

i get this error with that:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'LENGTH(name)' in 'order clause' (SQL: select * from pizzas order by LENGTH(name) asc, name asc)

@WebKenth you are right. I just double check my database, somehow even i set integer in my migration it was varchar in database. once i correct it to integer in database, the result is fixed. Thank you :)

May be you can try this than-

->orderByRaw('LENGTH(name) asc')

@lexionlu if my comment answered your question, be sure to mark it as an answer so others can quickly find the correct answer :)

@WebKenth thanks, i did mark it as answered. Cheers.

@tisuchi your solution works as well once i correct with

->orderByRaw('LENGTH(name) asc')

Thanks. :)

$pizzas = Pizza::all()->sortBy("name");

Order the resulting collection

$unorderedThings = Thing::orderBy('id')->get();
$orderedThings = $unorderedThings->sort();