Question

mysql数据库中用数据库字段作为变量进行LIKE模糊查询！请看详细补充！

如：我要查询tb_mgoodsmoretype中编号为10,121的数据，并根据其编号gmt_Id_i 在tb_mgoods 表中统计这个编号对应的数据条数 补充：goods_MoreType_v的数据格式为[10][12],或者[121][1789]

select gmt_Id_i ,gmt_Name_v,
(select count(*) from tb_mgoods where goods_MoreType_v like '%[gmt_Id_i]%') as counts
from tb_mgoodsmoretype where gmt_Id_i in(10,121)

在线等万分感谢！
请看清问题我是要用LIKE，不是直接等于！因为goods_MoreType_v数据格式是 [10][121] 之类的，而我的gmt_Id_i数据是编号 10 等
不是要下面这样！
【select gmt_Id_i ,gmt_Name_v,
(select count(*) from tb_mgoods where goods_MoreType_v=tb_mgoodsmoretype.gmt_Id_i) as counts
from tb_mgoodsmoretype where gmt_Id_i in(10,121) 】

Answer 1

select gmt_Id_i ,gmt_Name_v,
(select count(*) from tb_mgoods where goods_MoreType_v=tb_mgoodsmoretype.gmt_Id_i) as counts
from tb_mgoodsmoretype where gmt_Id_i in(10,121)

Answer 2

select gmt_Id_i ,gmt_Name_v,
(select count(*) from tb_mgoods where goods_MoreType_v like '%[’ + gmt_Id_i + ‘]%') as counts
from tb_mgoodsmoretype where gmt_Id_i in(10,121)