-+
| 4 | bar | 42.00 | 54.625 |
| 1 | foo |9.00 | 47 |
++--+-+-+
2 rows in set (0.00 sec)
So now I'm completely confused. Anyone have an explanation?
____________
Eamon Daly
- Original Message
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 * in_value
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
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 |
++--+---+---+-
