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);
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.
This is not still sorting the code..
orderByRaw('-images_id', 'DESC')
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
the syntax of the post from @samalapsy should be
orderByRaw('-images_id DESC')
without the parameters
Please or to participate in this conversation.