Re: Inverse Function

2001-04-18 Thread Benjamin Pflugmann
Hi. On Wed, Apr 18, 2001 at 04:17:45PM +0800, [EMAIL PROTECTED] wrote: > Siggy... > > thanks for the past reply... > > but i i dont want to SORT the record in ASCENDING or DESCENDING order > just a plain invert... That doesn't make really sense. According to the SQL specification, without ORDE

Re: inverse function

2001-04-17 Thread phobo
use the ORDER BY clause with the SELECT SELECT * FROM table ORDERBY fieldname ASC (or replace ASC with DESC for descending order) Siggy - Original Message - From: "Michael M. Ocana" <[EMAIL PROTECTED]> To: "Mysql Lists" <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 2:55 PM Subjec