MySQL query custom sorting from function

Question

Lets say i have a table that has the following field names

'id' 'likes' 'rating' 'view'

A normal MySQL sort would require a simple

SELECT * FROM $table ORDER BY likes DESC, rating DESC, view DESC

Now lets say I would want to order the given entries in my table by an arbitrary function

function custom_sort(likes, rating, view) {
    fame = 0.5 * like + 0.25 * rating - view;
    return fame;
}

I want to know if it is possible to do this pseudo code like action

 SELECT * FROM $table ORDER BY custom_sort(likes, rating, view) DESC

You even can do it without any functions, just write all this (I mean 0.5 * like + 0.25 * rating - view) in ORDER BY clause. — Devart
– Devart, Commented Aug 15, 2012 at 9:53

raina77ow · Accepted Answer · 2012-08-15 09:53:24Z

1

How about simply...

SELECT * FROM $table ORDER BY ( 0.5 * likes + 0.25 * rating - view ) DESC

answered Aug 15, 2012 at 9:53

raina77ow

107k16 gold badges205 silver badges240 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

toxicate20 Over a year ago

this only works if you use normal math operators like +-/* but what about php functions like min/max?

raina77ow Over a year ago

@toxicate20 Yes, but you should not confuse these functions with the aggregate ones. For example, you can write something like... 0.5 * LEAST(likes, 0.5) in your ORDER BY expression just fine.

Collectives™ on Stack Overflow

MySQL query custom sorting from function

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related