函数构造
1、变量varstring
2、计算变量varstring的长度
3、截取varstring并正则判断
4、将判断结果追加到变量v_temp
5、循环3-4
6、返回v_temp
SET @c='/BayerPharmaAG//BayerPharmaAG拜耳医药保健有限公司';
set global log_bin_trust_function_creators=TRUE;
-- 定义函数
DROP FUNCTION GetChinse;
CREATE FUNCTION GetChinse(varstring VARCHAR(255))
RETURNS VARCHAR(255)
BEGIN
DECLARE v_length INT DEFAULT 0;
DECLARE v_temp VARCHAR(255) DEFAULT '';
SET v_length=CHAR_LENGTH(varstring);
WHILE v_length>0 DO
IF MID(varstring,v_length,1) REGEXP'[\\u4e00-\\u9fa5]' THEN
SET v_temp=CONCAT(v_temp,MID(varstring,v_length,1));
-- ELSE
-- statement_list
END IF;
SET v_length=v_length-1;
END WHILE;
RETURN REVERSE(v_temp);
END;
SELECT GetChinse(@c);