Skip to content

Instantly share code, notes, and snippets.

@vansosnin

vansosnin/multiple_columns_sort.sql

Created September 8, 2015 04:55
Show Gist options
  • Save vansosnin/fa91dc57e32e42d9ffdb to your computer and use it in GitHub Desktop.
Save vansosnin/fa91dc57e32e42d9ffdb to your computer and use it in GitHub Desktop.
Download ZIP
Sort by price products sorted by img.
Raw
multiple_columns_sort.sql
SELECT * FROM prod ORDER BY IF(img,1,0) DESC, price DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment