In article [EMAIL PROTECTED],
Eamon Daly [EMAIL PROTECTED] writes:
SELECT
CASE
WHEN in_method = 'Add' THEN value + in_value
WHEN in_method = 'Subtract' THEN value - in_value
WHEN in_method = 'Multiply' THEN value * in_value
WHEN in_method = 'Divide' THEN value / in_value
END as
I thought about using a user variable to store the results of the phase_1
calculation. That would have changed the query to be:
SELECT
@p1 := CASE
WHEN in_method = 'Add' THEN value + in_value
WHEN in_method = 'Subtract' THEN value - in_value
WHEN in_method = 'Multiply' THEN value *
: [EMAIL PROTECTED]
To: Eamon Daly [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 26, 2004 8:15 AM
Subject: Re: Calculating a value based on an aliased column
I thought about using a user variable to store the results of the phase_1
calculation. That would have changed the query
Okay, I'm at my wit's end on this one. Suppose I have a
(grossly simplified) table like so:
mysql select * from filter;
++--+---+---+--++---+
| id | name | value | in_method | in_value | out_method | out_value |