mysql.js 模糊查询拼接

Question

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
模糊查询

Answer 1

等待大神解答