Checking if a field contains a string

Question

I m looking for an operator  which allows me to check  if the value of a field contains a certain string    Something like   db users findOne   contains   username   son       Is that possible

User · Answer

Simplest way to accomplish this task

If you want the query to be case-sensitive

db.getCollection("users").find({'username':/Son/})

If you want the query to be case-insensitive

db.getCollection("users").find({'username':/Son/i})

User · Answer

You can do it with the following code   db users findOne   username      regex      son

User · Answer

As this is one of the first hits in the search engines  and none of the above seems to work for MongoDB 3 x  here is one regex search that does work   db users find     name        regex    yourvalue    options     i          No need to create and extra index or alike

User · Answer

As Mongo shell support regex  that s completely possible   db users findOne   username       son         If we want the query to be case-insensitive  we can use  i  option  like shown below   db users findOne   username       son   i      See  http   www mongodb org display DOCS Advanced Queries AdvancedQueries-RegularExpressions

User · Answer

As of version 2 4  you can create a text index on the field s  to search and use the  text operator for querying   First  create the index   db users createIndex     username    text       Then  to search   db users find     text     search   son         Benchmarks   150K documents     Regex  other answers     5 6-6 9 seconds Text Search     164- 201 seconds   Notes    A collection can have only one text index  You can use a wildcard text index if you want to search any string field  like this  db collection createIndex            text       A text index can be large  It contains one index entry for each unique post-stemmed word in each indexed field for each document inserted  A text index will take longer to build than a normal index  A text index does not store phrases or information about the proximity of words in the documents  As a result  phrase queries will run much more effectively when the entire collection fits in RAM

User · Answer

This should do the work  db users find   username     in     son i           The i is just there to prevent restrictions of matching single cases of letters   You can check the  regex documentation on MongoDB documentation  Here s a link  https   docs mongodb com manual reference operator query regex

User · Answer

For aggregation framework  Field search    options    i  for case insensitive search  db users aggregate                  match                 email       regex     gmail com     options    i                          Full document search  only works on fields indexed with a text index db articles aggregate                  match     text     search   brave new world

User · Answer

Here s what you have to do if you are connecting MongoDB through Python  db users find   username      regex            Son              you may also use a variable name instead of  Son  and therefore the string concatenation

User · Answer

https   docs mongodb com manual reference sql-comparison   http   php net manual en mongo sqltomongo php  MySQL  SELECT   FROM users WHERE username LIKE   Son     MongoDB  db users find  username  Son

User · Answer

How to ignore HTML tags in a RegExp match   var text     lt p gt The  lt b gt tiger lt  b gt    lt i gt Panthera tigris lt  i gt   is the largest  lt a href   wiki Felidae  title  Felidae  gt cat lt  a gt   lt a href   wiki Species  title  Species  gt species lt  a gt   most recognizable for its pattern of dark vertical stripes on reddish-orange fur with a lighter underside  The species is classified in the genus  lt i gt  lt a href   wiki Panthera  title  Panthera  gt Panthera lt  a gt  lt  i gt  with the  lt a href   wiki Lion  title  Lion  gt lion lt  a gt    lt a href   wiki Leopard  title  Leopard  gt leopard lt  a gt    lt a href   wiki Jaguar  title  Jaguar  gt jaguar lt  a gt   and  lt a href   wiki Snow leopard  title  Snow leopard  gt snow leopard lt  a gt   It is an  lt a href   wiki Apex predator  title  Apex predator  gt apex predator lt  a gt   primarily preying on  lt a href   wiki Ungulate  title  Ungulate  gt ungulates lt  a gt  such as  lt a href   wiki Deer  title  Deer  gt deer lt  a gt  and  lt a href   wiki Bovid  class  mw-redirect  title  Bovid  gt bovids lt  a gt   lt  p gt    var searchString    largest cat species    var rx       searchString split      forEach e   gt      rx        e         s     lt      w   lt  gt    gt     s            rx   new RegExp rx   igm     console log text match rx      This is probably very easy to turn into a MongoDB aggregation filter

User · Answer

ideal answer its use index  i option for case-insensitive  db users findOne   username    new RegExp search value   i

User · Answer

If your regex includes a variable  make sure to escape it  function escapeRegExp string      return string replace                     g       amp          amp  means the whole matched string    This can be used like this new RegExp escapeRegExp searchString    i    Or in a mongoDb query like this     regex   escapeRegExp searchString     Posted same comment here

[mongodb] Checking if a field contains a string

Examples related to mongodb