在实际开发中,我们经常用到mysql的in 用法.可是当我们要实现
'abc' in 'abc,abc,acd'
这样就不行了。。于是用该函数代替。。。
clum varchar(32) ,par varchar(128)
BEGIN
DECLARE i int default 0;
DECLARE lfstr varchar(128) default ' ';
DECLARE instrs varchar(50);
DECLARE result tinyint(1) ;
SET result=false;
WHILE lfstr <> par do
set i=i+1;
set lfstr=substring_index(par,",",i);
set instrs=substring_index(lfstr,",",-1);
insert into test (name) value(instrs);
IF clum = instrs THEN
SET result=true;
RETURN result;
END IF;
END WHILE;
RETURN result;
END
'abc' in 'abc,abc,acd'
这样就不行了。。于是用该函数代替。。。
clum varchar(32) ,par varchar(128)
BEGIN
DECLARE i int default 0;
DECLARE lfstr varchar(128) default ' ';
DECLARE instrs varchar(50);
DECLARE result tinyint(1) ;
SET result=false;
WHILE lfstr <> par do
set i=i+1;
set lfstr=substring_index(par,",",i);
set instrs=substring_index(lfstr,",",-1);
insert into test (name) value(instrs);
IF clum = instrs THEN
SET result=true;
RETURN result;
END IF;
END WHILE;
RETURN result;
END