mySQL - query to get floor() or round() to next lowest 100 unit (hundred block number for address)

Question

I am trying to create a query to take integer street address numbers and get the hundred block number for the address. E.g. any value from 300 to 399 yields 300 etc.

Is this possible in a single query or should I write a script?

Answer 1

you can use floor like this :

SELECT FLOOR(399/100)*100;