Get a random integer between start and stop excluded

RANDOM_INTEGER.sql

-- Get a random integer between start and stop excluded
-- Author : sfaut <https://github.com/sfaut>
-- Publication date : 2023-03-11
-- Tested with MySQL 8.0.32 (@@sql_mode='ANSI,TRADITIONAL')

CREATE FUNCTION RANDOM_INTEGER(start INT, stop INT)
RETURNS INT
NOT DETERMINISTIC
NO SQL
COMMENT 'Get a random integer between start and stop excluded'
RETURN FLOOR(start + RAND() * (stop - start));