is_prime FUNCTION

gistfile1.txt

DELIMITER //
CREATE FUNCTION IF NOT EXISTS is_prime (number INT) RETURNS BOOLEAN
BEGIN
    DECLARE i INT DEFAULT 2;
    find_prime: WHILE i < number DO
            IF number % i = 0 THEN
                RETURN FALSE;
            END IF;
            SET i = i + 1;
        END WHILE find_prime;
    RETURN TRUE;
END //
DELIMITER ;