DELIMITER $$
CREATE FUNCTION fn_verifyCode
(code1 VARCHAR(45), code2 VARCHAR(45)) RETURNS BOOLEAN
BEGIN
DECLARE ok BOOLEAN;
SET ok = FALSE;
IF (code1 = code2) THEN
SET ok = true;
END IF;
RETURN ok;
END
$$
DELIMITER ;
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
DELIMITER $$
CREATE FUNCTION fn_verifyCode
(code1 VARCHAR(45), code2 VARCHAR(45)) RETURNS BOOLEAN
BEGIN
DECLARE ok BOOLEAN;
SET ok = FALSE;
IF (code1 = code2) THEN
SET ok = true;
END IF;
RETURN ok;
END
$$
DELIMITER ;