MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Gurhan Ozen Date:May 15 2002 9:14pm
Subject:RE: Simple SQL
View as plain text  
Please give us more insight on this. Is the column where you store dates (or
months) is a date datatype column?? If yes you can just do

SELECT ... FROM table_name ORDER BY MONTH(column_name);

It'll help to see your table structure to help you.


-----Original Message-----
From: Peter Sampson [mailto:frontpages@stripped]
Sent: Wednesday, May 15, 2002 3:06 PM
To: mysql@stripped
Subject: Simple SQL

SQL beginner using Macromedia Ultradev. Can you help?

Please be gentle I'm not  a programmer!

I am using

Select DISTINCT Month
FROM tblNews

The problem is that the months are shown alphabetical not in calendar order.

How can I change this?

Before posting, please check:   (the manual)           (the list archive)

To request this thread, e-mail <mysql-thread109148@stripped>
To unsubscribe, e-mail
Trouble unsubscribing? Try:

DBI connect (help)Taylor Lewick15 May
  • Simple SQLPeter Sampson15 May
    • RE: Simple SQLGurhan Ozen15 May
      • Re: Simple SQLPeter Sampson15 May
        • RE: Simple SQLRoger Baklund16 May
      • Re: Simple SQLPeter Sampson15 May
  • Re: Simple SQLRodney Broom15 May
    • RE: Simple SQLRoger Baklund15 May
  • Re: Simple SQLMark15 May