Then try:
select somefields,fieldname + 0 as orderfield order by orderfield
John Almberg wrote:
>Nope. I've tried every combination I can think of of these ideas. They all
>give syntax errors. I don't think arithmatic is allowed in an ORDER BY
>clause. Doesn't even work on an INT field.
>
>--
--Original Message-
> From: Mark Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 27, 2002 1:33 PM
> To: John Almberg
> Cc: Mysql
> Subject: Re: FW: SQL question
>
>
> John Almberg wrote:
>
> >Nope. I've tried every combination I can think of o
Yes, that works! Thanks very much to all who suggested similar solutions!
-- John
> -Original Message-
> From: Mark Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 27, 2002 1:33 PM
> To: John Almberg
> Cc: Mysql
> Subject: Re: FW: SQL question
>
&g
Yes, that works! Thank you very much!
-- John
> -Original Message-
> From: Mark Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 27, 2002 1:33 PM
> To: John Almberg
> Cc: Mysql
> Subject: Re: FW: SQL question
>
>
> John Almberg wrote:
&
A couple things off the top of my head:
- Have you looked into MySQL's 'SET' type?
- What about something like SELECT 0+fieldname as zerofield FROM table ORDER
BY zerofield;
- Would using grouping help?
- Have you considered creating a custom character set? (This may be too
extreme. Can be d
John Almberg wrote:
>Nope. I've tried every combination I can think of of these ideas. They all
>give syntax errors. I don't think arithmatic is allowed in an ORDER BY
>clause. Doesn't even work on an INT field.
>
>-- John
>
>
Have you tried a computed column, i.e,
SELECT BLAH, 0 + BLAH as ord
Here is a small example I have just run :
mysql> create table test (f char(20));
Query OK, 0 rows affected (0.90 sec)
mysql> insert into test values ('11xbc');
Query OK, 1 row affected (0.01 sec)
mysql> insert into test values ('2bcv');
Query OK, 1 row affected (0.00 sec)
mysql> insert into te