gistfile1.txt

mysql55> CREATE FUNCTION rrand (start INT, end INT) RETURNS INT NO SQL RETURN RAND() * (end - start) + start;
Query OK, 0 rows affected (0.00 sec)

mysql55> SELECT rrand(1, 3);
+-------------+
| rrand(1, 3) |
+-------------+
|           2 |
+-------------+
1 row in set (0.00 sec)

mysql55> SELECT rrand(1, 3);
+-------------+
| rrand(1, 3) |
+-------------+
|           3 |
+-------------+
1 row in set (0.00 sec)

mysql55> SELECT rrand(1, 3);
+-------------+
| rrand(1, 3) |
+-------------+
|           1 |
+-------------+
1 row in set (0.00 sec)