微信小程序云开发中模糊查询

1.单字段

var keyWord = 'abc'
const db = wx.cloud.database()
const _ = db.command
db.collection('product').where({
  title: {
    $regex: '.*' + keyWord,
    $options: 'i'
  }
}).get()

2.多字段

var keyWord = 'abc'
const db = wx.cloud.database()
const _ = db.command
db.collection('product').where(_.or([
  {
    title: db.RegExp({
      regexp: '.*' + keyWord,
      options: 'i',
    })
  },
  {
    subtitle: db.RegExp({
      regexp: '.*' + keyWord,
      options: 'i',
    })
  }
])).get()