SET @str = '<span itemprop="operatingSystem">1234567</span>';
SET @strLeft = '<span itemprop="operatingSystem">';
SET @strRight = '</span>';
SELECT SUBSTR(@str,INSTR(@str,@strLeft) + LENGTH(@strLeft),INSTR(@str,@strRight) - LENGTH(@strLeft) - 1) str1;
执行结果如下: