ot the same.
What field types are you using? Mine are as follows:
RoomNo VarChar(10)
LastName VarChar(25)
FirstName VarChar(25)
the values that I put into Room No are "1","2","3", etc. I'm not
storing "001","002
,firstname,lastname from
test.names) A
order by text,lastname,firstname;
- Original Message -
From: "Jesse" <[EMAIL PROTECTED]>
To: "Zhaowei" <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Sent: Friday, March 23, 2007 11:23:21 AM (GMT-0500) Auto-Detected
Subject
not storing
"001","002","003", etc in there.
Jesse
- Original Message -
From: "Zhaowei" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>;
Sent: Friday, March 23, 2007 5:03 AM
Subject: Re: Not Sorting Correctly
Hi
make an alias for the field you want as sort key and use that. you
don't need to do the calculation twice. I would not be surprised if
the sort started to behave.
Didn't help. The results are exactly the same.
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
From: "Ales Zoulek" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Monday, March 19, 2007 9:06 PM
Subject: Re: Not Sorting Correctly
> pls, post result of:
>
> SELECT RIGHT(CONCAT('000,RoomNo),3),LastName,FirstName FRO
inal Message -
From: "Ales Zoulek" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Monday, March 19, 2007 9:06 PM
Subject: Re: Not Sorting Correctly
> pls, post result of:
>
> SELECT RIGHT(CONCAT('000,RoomNo),3),Last
L PROTECTED]>
Cc: "MySQL List"
Sent: Monday, March 19, 2007 9:06 PM
Subject: Re: Not Sorting Correctly
pls, post result of:
SELECT RIGHT(CONCAT('000,RoomNo),3),LastName,FirstName FROM
Ales
On 3/19/07, Jesse <[EMAIL PROTECTED]> wrote:
I have an app that I've co
pls, post result of:
SELECT RIGHT(CONCAT('000,RoomNo),3),LastName,FirstName FROM
Ales
On 3/19/07, Jesse <[EMAIL PROTECTED]> wrote:
I have an app that I've converted to MySQL from MS SQL. I used to use the
following to force a Alpha field to sort as if it were numeric (I know,
perhaps it
I have an app that I've converted to MySQL from MS SQL. I used to use the
following to force a Alpha field to sort as if it were numeric (I know,
perhaps it is better if I made the field numeric to begin with, but it's
not, and I don't remember why, but that's not the question here):
ORDER BY
