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
With out knowing the exact error im guess its because you're trying to
start the server as root.
Sheena Sidhu wrote:
>
> Hi All,
> I have installed mysql-max. Previously I had the mysql verion 3.23.40
> without max libraries on the same machine. When I start the server , I get
> the fol
select *,DATE_FORMAT(datecolumn,'%M %D %Y');
On Tue, 16 Jan 2001, Mike Podlesny wrote:
>
> > Thanks for your help but that unfortunately doesn't answer the question,
> > unless I am looking at it wrong. I want the sql statement to read
> something
> > to the affect:
> >
> > SELECT * FROM Table
