SELECT *
FROM tbl_product_store
WHERE (SUBSTRING(product_no, 2, 1) = '8')
查询字段product_no第二位起到第三位字段是8 的数据
SELECT *
FROM tbl_product_store
WHERE (SUBSTRING(product_no, 2, 1) = '8')
查询字段product_no第二位起到第三位字段是8 的数据
转载于:https://www.cnblogs.com/xiaofengfeng/archive/2010/11/20/1882528.html