SUBSTRING_INDEX语法图SUBSTRING_INDEX函数提取expr表示的字符串中在分隔符指定次数出现之前的子字符串。...示例SELECT SUBSTRING_INDEX('192.168.0.1',0.1, 1) a,SUBSTRING_INDEX('192.168.0.1','....', 2) b,SUBSTRING_INDEX('192.168.0.1','.', 3) c,SUBSTRING_INDEX('192.168.0.1','....',1) a,SUBSTRING_INDEX('192.168.0.1',NULL,1) b,SUBSTRING_INDEX('192.168.0.1','.'...', 2) b,SUBSTRING_INDEX('192.168.0.1','.', 3) c,SUBSTRING_INDEX('192.168.0.1','.