DELIMITER //
CREATE FUNCTION rand_int()
RETURNS INT
NOT DETERMINISTIC
NO SQL
BEGIN
RETURN ROUND(RAND() * 1000);
END//
SELECT rand_int() AS random_number;
This SELECT statement is calling this FUNCTION and yields this result