[thelist] MySQL SELECT statement and functions

Joshua Olson joshua at alphashop.net
Wed Jun 27 22:21:42 CDT 2001


Oops, fergot to remove the Floor from my ORDER BY clause,

shoulda been

: SELECT
:   $table_name.*,
:   Floor(orderid) AS floor_id
: FROM $table_name
: WHERE orderid NOT LIKE '%x%'
: ORDER BY floor_id ASC

sorry.  Getting very late.  :)

-joshua


----- Original Message ----- 
From: "Joshua Olson" <joshua at alphashop.net>
Subject: Re: [thelist] MySQL SELECT statement and functions


: Not ever really used MySQL, but what about:
: 
: SELECT
:   $table_name.*,
:   Floor(orderid) AS floor_id
: FROM $table_name
: WHERE orderid NOT LIKE '%x%'
: ORDER BY Floor(floor_id) ASC






More information about the thelist mailing list