MySQL按关键字截取字符串substring_index

SELECT  ip, SUBSTRING_INDEX(ip, '-', 1) AS ipstart,   SUBSTRING_INDEX(ip, '-', -1) AS ipend FROM orgip;