mysql+koa 模糊查询

最新推荐文章于 2024-02-15 18:05:10 发布

weixin_33736048

最新推荐文章于 2024-02-15 18:05:10 发布

阅读量811

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：https://juejin.im/post/5aba28d06fb9a028c71e7867

// 分类搜索
let searchCategory = (category) => {
  let _sql = `select * from categories where category like "%${category}%";`
  return query(_sql)
}
复制代码

router.get('/categorySearch/:category',async(ctx,next) => {
    let category = ctx.params.category;
    console.log(category)
    await userModel.searchCategory(category)
        .then(result => {
            console.log(result)
            ctx.body = {
                code: 200,
                msg: '删除成功',
                data: result
            }
        })
})
复制代码