Eamon Daly
- Original Message -
From: "N. Kavithashree" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, January 25, 2005 1:19 AM
Subject: orderbymonths
hello,
is there any way so that months r ordered as that of calender year.
means . i have a month field of 3 chars. like Jan
Hello.
May be you should think about the ENUM type. See:
http://dev.mysql.com/doc/mysql/en/enum.html
For example:
create table mon(mon enum('Jan','Feb','Mar','Apr' , 'May' , 'Jun' , 'Jul' ,
'Aug' , 'Sep' , 'Oct' , 'Nov' , 'Dec') , a int);
insert into mon values('Jan',5);
insert into
hello,
is there any way so that months r ordered as that of calender year.
means . i have a month field of 3 chars. like Jan, Feb, Mar etc
when i select distinct months , the result will be displayed in the
calender year month order.
but if i use order by mon then this order jan,feb,mar will g