ofcource I can.
select a, b ,b*100/a as c, b*100/a-a/b, from mytable
that will work
you know, the idea is when I want to use
b*100/a many times as variable "c"
and MySql should not to multiplay and divide every time
select a, b ,b*100/a as c, c-a/b, c+d/a as e, e*100/b from mytable
what is the way to use these variables "c" and "e" in mysql 4.1 or 5.0