mysql calculation field stored in another field

Programmer Question

I have fields in mysql that look like this:

constant1 , constant2, variable1, variable2, formula

The formula field stores a formula utilizing constant1, constant2, variable1 and variable2.

For example, the formula field may contain a calculation like this:

constant1 * variable1

When I use a select statement like this:

SELECT constant1, constant2, variable1, variable2, formula
FROM table

How do I retrieve the calculation result of constant1 * variable1 based on formula field?

Find the answer here