using result as a field

[Mojtaba Faridzad]

Hi,

is that possible to use a result of a calculation as a field?  for example:

SELECT num1 + num2 AS var1, IF(var1 > 100, 'Good', 'Bad') FROM table1;

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]