Get comma exist document using mongodb query?

Question

User collection below

[
{
    "_id" : ObjectId("59a6b381c13a090c70fc21b6"),
    "Name":"ABC"
    "processNumber" : "FEE 082517",
    "Process":"abc,cde"
    
       
  },
  {
    "_id" : ObjectId("59a6b381c13a090c70fc21b6"),
    "Name":"ABC"
    "processNumber" : "FEE 082517",
    "Process":"efg"
    
       
  },
  {
    "_id" : ObjectId("59a6b381c13a090c70fc21b6"),
    "Name":"ABC"
    "processNumber" : "FEE 082517",
    "Process":"123,3de"
    
       
  }
 ]

I have a user collection. I have to prepare a query to check the Process field whether it has any comma in value if it's there we have to return those documents

Expected output :

 [
{
    "_id" : ObjectId("59a6b381c13a090c70fc21b6"),
    "Name":"ABC"
    "processNumber" : "FEE 082517",
    "Process":"abc,cde"
    
       
  },
  
  {
    "_id" : ObjectId("59a6b381c13a090c70fc21b6"),
    "Name":"ABC"
    "processNumber" : "FEE 082517",
    "Process":"123,3de"
    
       
  }
 ]

Does this answer your question? [Checking if a field contains a string](https://stackoverflow.com/questions/10610131/checking-if-a-field-contains-a-string) — turivishal, Jun 09 '21 at 13:36
Nope I want to get all the documents that have a comma(inside string)in Process field. — its me, Jun 09 '21 at 14:11
its same just use string whatever you want to search in field, `{ Process: { $regex: "," } }` — turivishal, Jun 09 '21 at 14:21

score 0 · Accepted Answer · answered Jun 15 '21 at 06:13

0

Search in field

{ Process: { $regex: "," } }

Query Should be

db.collection.find({ 'fieldname': { $regex: "," } })

@turivishal thanks for your answer

answered Jun 15 '21 at 06:13

its me

524
6
28
62

Get comma exist document using mongodb query?

1 Answers1