MySQL generating a random integer between a min and a max

Say you want to generate a number between a and b, you can do the following:

select (FLOOR(a + RAND() * (b - a) ))