How can I round a number down to the nearest 10?

Question

In MySQL I would like to round numbers down to the nearest ten.

e.g. 812 -> 810, but also 819 -> 810

Using the ROUND function does not do the trick.

Answer 1

I would divide by 10, do a floor() then multiply by 10 to get the proper int value. So in MySQL something like that :

SELECT FLOOR(Myattribute / 10) * 10;