try
ORDER BY (Category = 'Other'), Category, Subcategory
It should work, (I hope ^_-;;;)
- Original Message -
From: "Jeff Shipman - SysProg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001 8:38 PM
Subject: complicated query
> I would like to do something similar
As Far as I can remember it is explicitly said in the Manual that inserting
a negative value in an autoincrement field is a Bad Thing
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 6:14 AM
Subject: Possible bug in 3.23.32 or later
- Original Message -
From: "Ron Beck" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 7:12 PM
Subject: Re: Display information
> SELECT id,lot_id,lot_type FROM scrap_table
> ORDER BY id limit 1932,10;
>
> seemed promising but it put them in oldest-to-newest
I think that this will do
SELECT -(Sum(Rating-2)) AS Total
FROM Rating
GROUP BY 1;
- Original Message -
From: "Mike Podlesny" <[EMAIL PROTECTED]>
To: "Tomi Junnila" <[EMAIL PROTECTED]>; "mySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 4:50 PM
Subject: HELP with SQ
- Original Message -
From: <[EMAIL PROTECTED]>
To: "mySQL list" <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 2001 3:57 PM
Subject: Why does 1st query take so long?
> I've noticed that when developing queries involving complex joins on
> tables I sometimes seem to get appallingly long
