select substr(destination_ip,1,instr(destination_ip,';')-1) as ip from fact_dns_cdr;
截取分号结尾的字符
最新推荐文章于 2020-11-16 18:37:32 发布
select substr(destination_ip,1,instr(destination_ip,';')-1) as ip from fact_dns_cdr;