[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