SELECT id % 24 FROM table

SELECT id % 24 + 1 FROM table

Modulo operation. Returns the remainder of N divided by M.


mysql> SELECT MOD(234, 10);
        -> 4
mysql> SELECT 253 % 7;
        -> 1
mysql> SELECT MOD(29,9);
        -> 2
mysql> SELECT 29 MOD 9;
        -> 2