java测试正则:
public static void main(String[] args) { GanXian ganXian = new GanXian(); String rex = "T1\\D"; Pattern.compile(rex); }
正则匹配中文:"[\u4e00-\u9fa5]"
正则截取示例:
SELECT route_code,REGEXP_extract(route_code,'(395)(\\S+)(371)',0) new_route from dm_ops.rpt_route_city_route where inc_day='20190529' and route_code rlike '395\\S+371