----- 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:[EMAIL PROTECTED]
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]