select substr(destination_ip,1,instr(destination_ip,';')-1) as ip from fact_dns_cdr;
截取分号结尾的字符
最新推荐文章于 2021-05-13 09:21:17 发布
select substr(destination_ip,1,instr(destination_ip,';')-1) as ip from fact_dns_cdr;