如果输入当前值和期望值相等则返回值自定义返回值
CREATE DEFINER = `root`@`%` FUNCTION `strConversion`(currentVaule VARCHAR(5) ,expectValue VARCHAR(5) , retunrnVaule VARCHAR(5))
RETURNS varchar(5)
COMMENT '如果输入当前值和期望值相等则返回值自定义返回值'
BEGIN
DECLARE strValue VARCHAR(5) DEFAULT '';
IF(currentVaule = expectValue) then
set strValue = retunrnVaule;
ELSE
set strValue = currentVaule;
END IF;
RETURN strValue;
END;
执行完成查看结果
select strConversion('1','1','5')