select COUNT(id) from biz_productall where (barcode REGEXP '[^0-9]') != 0 AND barcode != ''
AND product_no in(select product_no FROM biz_productinfoextend WHERE organize_id = 10004)
SQL 正则表达式检索数据表中某字段值全是数字
最新推荐文章于 2022-10-14 19:04:42 发布
select COUNT(id) from biz_productall where (barcode REGEXP '[^0-9]') != 0 AND barcode != ''
AND product_no in(select product_no FROM biz_productinfoextend WHERE organize_id = 10004)