Right now I am sorting a table for a query by the contents in a column called "col1".
mysql_query("SELECT * FROM table ORDER BY col1 DESC");
Instead, I would like to calculate a "score" to sort the table by.
score = ((col1-2)*col2)+col3)
Is this possible?