> Is there a way to extract lets say a bunch of dates from a
> mysql db, and the sort them in order from newest to oldest?
> Also how would you sort names in alphabetical order?
Yes, and a php list is obviously a good place to ask an sql question.
In any case, you want to examine your favo
On Tuesday 21 May 2002 10:11, Cleeker wrote:
> Is there a way to extract lets say a bunch of dates from a mysql db, and
> the sort them in order from newest to oldest? Also how would you sort
> names in alphabetical order?
Yes, look at the date/time functions in the (mysql) manual.
--
Jason Won
The MySQL manual will explain this in great detail.
To sort by date:
SELECT * FROM table ORDER BY date ASC;
for that to work, all the values in date should be a timestamp (ex:
2002052000)
To sort by names:
SELECT * FROM table ORDER BY name ASC;
If you want reverse the order, replace the '
On Mon, 20 May 2002, Cleeker wrote:
> Is there a way to extract lets say a bunch of dates from a mysql db, and
> the sort them in order from newest to oldest? Also how would you sort
> names in alphabetical order?
Read the section of the MySQL manual that covers "ORDER BY" clauses.
miguel
--
4 matches
Mail list logo