How can I make this work ? SELECT a_very_very_long_function_to_repeate_in_where_clausule(parm1,parm2) as short_form WHERE short_form<=2 ; This syntaxe produces a error, so what is the correct form to alias one colum with a long name that we use on WHERE ?
Sir, you need a FROM clause. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak -- --------------------------------------------------------------------- Please check "http://www.mysql.com/documentation/manual.php"; before posting. To request this thread, e-mail mysql-thread60332@xxxxxxxxxxxxxxx To unsubscribe, send a message to: <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx> If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php