sql - 如何用“ like”查询MongoDB？(How to query MongoDB with “like”?)

Question

I want to query something with SQL's like query:

(我想查询一些与SQL的like查询：)

SELECT * FROM users  WHERE name LIKE '%m%'

How to do I achieve the same in MongoDB?

(我如何在MongoDB中实现相同目标？)

I can't find an operator for like in the documentation .

(我在文档中找不到like的运算符。)

  ask by Freewind translate from so

Answer 1

That would have to be:

(那必须是：)

db.users.find({"name": /.*m.*/})

or, similar:

(或类似：)

db.users.find({"name": /m/})

You're looking for something that contains "m" somewhere (SQL's ' % ' operator is equivalent to Regexp's ' .* '), not something that has "m" anchored to the beginning of the string.

(您正在寻找某种在某处包含“ m”的东西（SQL的' % '运算符等效于Regexp的' .* '），而不是在字符串开头固定了“ m”的东西。)

note: mongodb uses regular expressions which are more powerful than "LIKE" in sql.

(注意： mongodb使用的正则表达式比sql中的“ LIKE”更强大。)

With regular expressions you can create any pattern that you imagine.

(使用正则表达式，您可以创建您想像的任何模式。)

For more info on regular expressions refer to this link https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions

(有关正则表达式的更多信息，请参见此链接https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions)