psubbiah93@gmail.com

Wednesday, 18 November 2015

ORDER BY MONTH (string) FIELD IN MYSQL



//======================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;
=====================================
Unknown Web Developer

Hello! I am Subbiah P and this is my web technologies blog. My specialities are PHP, Asp.net, jQuery, and CMS web application development. I do accept paid work. Write to me to start working on your dream project . I am Working as Web developer in Peace Soft Technologies

No comments:

Post a Comment