[SOLVED] How to do this

[jaymc]

This does not work as there WHERE does not seem to be able to retreive the value of result

Select cheese, beans, (footballs - rabbits) as result
FROM beans 
WHERE result = 0

 

This does work

Select cheese, beans
FROM beans 
WHERE footballs - rabbits = 0

 

I need it working in the way showed in example 1

[Barand]

I need it working in the way showed in example 1

Then you're in for a disappointment. You can't use an alias in a WHERE clause as the alias doesn't exist in the table at the time of selection.

 

You could try HAVING instead of WHERE, as that is evaluated after the results are in. (Less efficient though as it will get the records only to exclude them later)

[fenway]

wb...

 

What's wrong with:

 

Select cheese, beans, (footballs - rabbits) as result
FROM beans 
WHERE (footballs - rabbits) = 0

[jaymc]

Dam

 

And nothings wrong with it, Im generating the queries dynamically via php and the alias method fitted in nice with what I have so far

 

Now Im going to have to use an if statement just for this part

 

I will live with it

 

Thanks guys