摘要:
如mysql中有个列如下数值,怎么提出出其中ip地址BGP-BeiJing-59.151.105.130-AD_read-YeZongKunBGP-BeiJing-59.151.105.138_140_141-AD_LVS-YeZongKun我提供sql语句如下:selectSUBSTRING(substring_index(‘BGP-BeiJing-59.151.105.130-AD_read-YeZongKun’,'-’,3),(length(substring_index(‘BGP-BeiJing-59.151.105.130-AD_read-YeZongKun’,'-’ 阅读全文