List:General Discussion« Previous MessageNext Message »
From:Mojtaba Faridzad Date:March 30 2004 8:49pm
Subject:using result as a field
View as plain text  
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;
Thread
Drop all keys / indexes on a table?Daevid Vincent29 Mar
  • Re: Drop all keys / indexes on a table?Victoria Reznichenko30 Mar
    • RE: Drop all keys / indexes on a table?Daevid Vincent30 Mar
      • Re: Drop all keys / indexes on a table?PeterWR30 Mar
        • RE: Drop all keys / indexes on a table?Daevid Vincent30 Mar
          • Re: Drop all keys / indexes on a table?John Thorpe30 Mar
            • RE: Drop all keys / indexes on a table?Daevid Vincent31 Mar
      • using result as a fieldMojtaba Faridzad30 Mar
      • RE: Drop all keys / indexes on a table?Daevid Vincent30 Mar