[thelist] MySQL SELECT statement and functions

[jon steele]

Hi all,

I'm trying to execute an sql select statement in MySQL, but wish to use
a function in the ORDER BY clause. This gives an error. When I remove
the Floor() function, it works. Does anyone know why this is and what I
can do to work around it? This is only with MySQL (a similar query in
MSAccess worked):

SELECT * FROM $table_name WHERE orderid	NOT LIKE '%x%' ORDER BY
Floor(orderid) ASC;

Any insight's appreciated.

Thanks,
Jon.

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/