MYSQL版:
drop FUNCTION if EXISTS test.chstr;-- test为库名CREATE FUNCTION test.chstr(s VARCHAR(255)) RETURNs VARCHAR(255) BEGIN DECLARE t_char VARCHAR(255);declare t_out VARCHAR(255);DECLARE i int;set t_out='';set i=CHAR_LENGTH(s);WHILE i>0 do set t_char=SUBSTR(s,i,1);if LENGTH(t_char)=3 then set t_out=CONCAT(t_char,t_out);END if;set i=i-1;end WHILE;RETURN(t_out);end drop FUNCTION if EXISTS test.c