Select int and division using MYSQL

Question

How to select int and then divide it by 100 using MYSQL?

Answer 1

Select (field / 100) as divided
  From Table;

Answer 2

Simple separation. The question is, do you want integer arithmetic?

For example, 163/100 = 1. Thus, you need to implicitly or explicitly convert it to get 1.63

SELECT MyColumn * 1.0 / 100 FROM MyTable

or

SELECT MyColumn / 100.0 FROM MyTable

Answer 3

Try this sql query:

SELECT 16800 /* = an int */ / 100