>Did you read the link?
>The OP wanted to know if MySQL supported the = sign in a SELECT statement.
The documentaion I referred the OP to clearly >differentiates the use of =
and := within SELECT statements and SET statements for MySQL. If the MySQL
behavior is not what >they were hoping for then they are now informed that a
form used in MS SQL to produce column aliases does not work the same >way on
MySQL platform and why it doesn't work that way. I don't think I could have
explained it myself any better than what >was already documented. Hence, the
simple RTFM answer....
Ah, just wanted to make clear you didn't mean to say something
along the lines of "with variables, you can use such and such and
you can work around it with this".
>BTW -- the "SELECT ID TAG_ID,..." form works equally well on MS SQL to
produce column aliases because it is ANSI >compliant.
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!