select * from table where (loginname REGEXP '[^0-9.]')=0 and createtime > '2018-12-01';
MySQL查询字段为纯数字的数据
最新推荐文章于 2023-11-16 15:31:48 发布
select * from table where (loginname REGEXP '[^0-9.]')=0 and createtime > '2018-12-01';