At 9:06 -0600 11/19/02, Carter, Scott wrote:
>The actual query is :
>SELECT * FROM PROFILES WHERE fname="scott" ORDER BY lastused;
>The lastused field is of type date, and I want the returned result set to be
>ordered by that date.
Still need more info. What dates are in the records with "scott" and
in what order are they returned?
>Thanks - Scott Carter
>From: Paul DuBois [mailto:paul@stripped]
>Sent: Monday, November 18, 2002 5:51 PM
>To: Carter, Scott; 'mysql@stripped'
>Subject: Re: simple question
>At 17:19 -0600 11/18/02, Carter, Scott wrote:
>>I want to sort my results by a date that is contained in the database table
>>the query is performed on. The ORDER BY clause does not seem to do the
>>trick. How do you do this?
>>Thanks - Scott Carter
>With ORDER BY. You'll have to provide more details so that we can
>see what the problem is with your query.