let products= await ctx.db.query(`select product.pid,product.title,product.detail,product.money,product.classify,product.imgurl
,provider.name,provider.phone,provider.componyname,provider.addr,provider.size,provider.logo
from product,provider
where 1=1 ${down?'and down=?':''} ${classify?'and classify=?':''} ${keyword?`and title like CONCAT(%,?,%) or detail like CONCAT(%,?,%)`:''} and product.prov=provider.pid`,
arr
)
arr [0,'标注','标注']
如何拼接才是正确的
后端:koa
数据库:mysql
模糊查询