SELECT ip, SUBSTRING_INDEX(ip, '-', 1) AS ipstart, SUBSTRING_INDEX(ip, '-', -1) AS ipend FROM orgip;MySQL按关键字截取字符串substring_index
发表评论
SELECT ip, SUBSTRING_INDEX(ip, '-', 1) AS ipstart, SUBSTRING_INDEX(ip, '-', -1) AS ipend FROM orgip;