//======================ORDER BY MONTH (string) FIELD IN DB ==============================//
Solution :1
===================================
SELECT * FROM `articles` where journal_id='1' ORDER BY
CASE `month`
WHEN 'January' THEN 1
WHEN 'February' THEN 2
WHEN 'March' THEN 3
WHEN 'April' THEN 4
WHEN 'May' THEN 5
WHEN 'June' THEN 6
WHEN 'July' THEN 7
WHEN 'August' THEN 8
WHEN 'September' THEN 9
WHEN 'October' THEN 10
WHEN 'November' THEN 11
WHEN 'December' THEN 12
ELSE 0 END;
=======================================
Solution : 2
============================================
SELECT * FROM `articles` where journal_id='1' ORDER BY FIELD(month,'January','Feburary','March','May','June','July','August','September','October','November','December') DESC,year DESC,volume DESC,issue DESC;
=====================================
No comments:
Post a Comment