Gossamer Forum
Home : General : Databases and SQL :

Re: [shazow] MYSQL Sorting by a calculated variable

Quote Reply
Re: [shazow] MYSQL Sorting by a calculated variable In reply to
Try:

SELECT field1, field2 FROM table ORDER BY field1 + field2

or:

SELECT field1, field2, field1 + field2 as field3 FROM table ORDER BY field3

TheStone.

B.
Subject Author Views Date
Thread MYSQL Sorting by a calculated variable shazow 3688 Oct 24, 2002, 8:06 AM
Thread Re: [shazow] MYSQL Sorting by a calculated variable
604 3603 Oct 24, 2002, 10:56 AM
Post Re: [TheStone] MYSQL Sorting by a calculated variable
shazow 3522 Oct 24, 2002, 3:27 PM