mysql 字符串拆分

    SET @s='aa,bb,cc';
    WHILE @s<>'' DO
        SET @p=LOCATE(',',@s);
        IF @p=0 THEN
            SET @p=LENGTH(@s)+1;
        END IF;
        SET @item = SUBSTRING(@s,1,@p-1);
        SET @s=SUBSTRING(@s,@p+1,LENGTH(@s)-@p);
        SELECT @item,@s;
    END WHILE;