Originally Posted by durangod
lets see if i remember) order is division, multiplication, addition, subtraction
Actually, multiplication and division have the same precedence. And addition and subtraction have the same precedence.
And why Google when MySQL spells it out carefully for you:
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.