MySQL按关键字截取字符串substring_index

作者: 吴杰 分类: 编程 发布时间: 2019-03-04 23:48 
SELECT  ip, SUBSTRING_INDEX(ip, '-', 1) AS ipstart,   SUBSTRING_INDEX(ip, '-', -1) AS ipend FROM orgip;

更多阅读
标签云
.net access apache asp.net asp.net core asp.net mvc bcb c c# c++ centos composer css curl debian delphi easyui ef git iis js laravel linux mariadb mfc mysql nginx oracle php python qt sqlserver ssh ssl supervisor ubuntu vc vim vs win32 windows winform wordpress wpf 采集