select '12.41212' ~ '^[0-9\.]+$' => true select 'Service' ~ '^[0-9\.]+$' => false
条件语句
是:select * from t_tab t where t.t_column ~ '^[0-9\.]+$'
否:select * from t_tab t where t.t_column !~ '^[0-9\.]+$'
select '12.41212' ~ '^[0-9\.]+$' => true select 'Service' ~ '^[0-9\.]+$' => false
条件语句
是:select * from t_tab t where t.t_column ~ '^[0-9\.]+$'
否:select * from t_tab t where t.t_column !~ '^[0-9\.]+$'