You might be tempted to rewrite your queries to make arithmetic
operations faster, while sacrificing readability. Because MySQL does
similar optimizations automatically, you can often avoid this work,
and leave the query in a more understandable and maintainable form.
Some of the optimizations performed by MySQL follow: