1.查询所有数据
select malCode from eam_run_malCode ;
2.查询只包含数字的数据
select malCode from eam_run_malcode c
where length(malCode)=12 and malCode like '20%' and replace(translate(malCode, '0123456789', '0'), '0', '') is null
1.查询所有数据
select malCode from eam_run_malCode ;
2.查询只包含数字的数据
select malCode from eam_run_malcode c
where length(malCode)=12 and malCode like '20%' and replace(translate(malCode, '0123456789', '0'), '0', '') is null