I don't think it is possible at the moment, and pretty sure its not standard SQL but it would still be neat to have
SELECT aField, COLUMN_IF( some_expression, 'afield2' AS 'aColumn' ) FROM aTable So in this example, if the expression was true, include that column in the result set, otherwise don't Sure this can be handled outside MySQL and just change the query on condition, just thought it would be nice --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php