ORDER BY problem

Hi

while testing an upgrade from 3.23.58 to 4.1.22 on an FC3 test box

SELECT * FROM Contacts WHERE Categories="Services" and BusinessCodes REGEXP
"^R" and gold_id="2" ORDER BY "Company" ASC

on mysql server3.23.58 i get company result in ASC order.
on mysql server4.1.22 i get non ASC order for companies.

is there something on 4.1.22 i missed that effects ORDER BY?

Mark

----- Original Message -----
Subject: RE: ORDER BY problem


> Try your query with either back quotes around Company
>
> SELECT * FROM Contacts WHERE Categories="Services" and BusinessCodes
> REGEXP
> "^R" and gold_id="2" ORDER BY `Company` ASC
>
> Or no quotes around Company
>
> SELECT * FROM Contacts WHERE Categories="Services" and BusinessCodes
> REGEXP
> "^R" and gold_id="2" ORDER BY Company ASC
>
> -----Original Message-----
> From: Obantec Support [mailto:support@obantec.net]
> Sent: Friday, July 11, 2008 9:29 AM
> To: mysql@lists.mysql.com
> Subject: ORDER BY problem
>
> Hi
>
> while testing an upgrade from 3.23.58 to 4.1.22 on an FC3 test box
>
> SELECT * FROM Contacts WHERE Categories="Services" and BusinessCodes
> REGEXP
> "^R" and gold_id="2" ORDER BY "Company" ASC
> on mysql server3.23.58 i get company result in ASC order.
> on mysql server4.1.22 i get non ASC order for companies.
>
> is there something on 4.1.22 i missed that effects ORDER BY?
>
> Mark
>
>
>
>
Hi Rolando

please only reply to the list.

Ok fixed now by either method. I have chosen to leave the "" off.
Thanks

Mark