MongoDB新驱动程序管理器正则表达式查询与MySQL类似查询相同

[
  {
    "_id": 1,
    "name": "Alice",
    "email": "alice@example.com"
  },
  {
    "_id": 2,
    "name": "Bob",
    "email": "bob@example.com"
  },
  {
    "_id": 3,
    "name": "Charlie",
    "email": "charlie@example.com"
  }
]

db.users.find({ "name": { "$regex": ".*li.*", "$options": "i" } })

[
  {
    "_id": 1,
    "name": "Alice",
    "email": "alice@example.com"
  },
  {
    "_id": 3,
    "name": "Charlie",
    "email": "charlie@example.com"
  }
]

SELECT * FROM users WHERE name LIKE '%li%';