摘要: 如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’,'-’ 阅读全文
posted @ 2012-09-04 11:52 坏混混 阅读(2934) 评论(0) 推荐(0) 编辑