CREATE DEFINER=`oneboss1`@`192.168.%.%` FUNCTION `f_find_province_by_name`(pname VARCHAR(50)) RETURNS int(11)
BEGIN
DECLARE province int(11);
IF(ISNULL(pname)) THEN RETURN NULL;
ELSE
SELECT id INTO province from b_zone where PARENT_ID=1 AND GRADE=0 AND (`NAME`=pname OR OTHER_NAME=pname or OTHER_NAME2=pname or OTHER_NAME3=pname or OTHER_NAME4=pname or OTHER_NAME5=pname);
RETURN province;
END IF;
END