formula on several field then do a between possible.

[phpmo]

I'm trying to do the following but it's not working. I've gotten it to work when I do an Order By but it's not working on the BETWEEN.

 

select field1,round(((f2+f3+f4)/3)) as newfield from table where newfield BETWEEN 2 AND 4 ORDER BY field1 asc limit 20

[jskywalker]

select field1,round(((f2+f3+f4)/3)) as newfield 
from table 
ORDER BY field1 asc 
having newfield BETWEEN 2 AND 4 
limit 20

or

select field1,round(((f2+f3+f4)/3)) as newfield 
from table 
where round(((f2+f3+f4)/3)) BETWEEN 2 AND 4 
ORDER BY field1 asc 
limit 20