Brent Baisley wrote:
calculations from your query, like replace datesub(now(), interval 12 month) with a constant. Which means figuring out the right date before hand.
AFAIK, no column is involved in this particular function, so there's no point doing the computation beforehand, it's done by mysql.
-- Philippe Poelvoorde COS Trading Ltd.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
