How to write Eloquent OrderBy() to put null columns to the last

Please hoe can I write an eloquent query to sort result by a column making all the null columns item appear last. Here is my code

->orderBy('images_id', 'DESC')  // This should show the ones with value first
->distinct()->Paginate(24);

Cronix

8 years ago

Level 67

With normal mysql, you'd add a - sign before the column, like -images_id. Don't know if that will work with query builder/eloquent or not, but it if doesn't you can use orderByRaw() and manually enter your order portion of the query.

3 likes

samalapsy

8 years ago

Level 2

This is not still sorting the code..

orderByRaw('-images_id', 'DESC')

Cronix

8 years ago

Level 67

Then you'll have to do it manually with raw sql (not query builder or eloquent) like I said above using orderByRaw.

See this post: https://stackoverflow.com/questions/2051602/mysql-orderby-a-number-nulls-last

WouterClaes

8 years ago

Level 1

the syntax of the post from @samalapsy should be

orderByRaw('-images_id DESC')

without the parameters

3 likes

Please or to participate in this conversation.