Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Search a string with special characters in a MongoDB document?
To search a string with special characters in MongoDB document, you can use \. Here, we have special character $ in our string.
Let us first implement the following query to create a collection with documents
>db.searchDocumentWithSpecialCharactersDemo.insertOne({"UserId":"Smith$John123","UserFirstName":"John","UserLastName":"Smith"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5c987b98330fd0aa0d2fe4b1")
}
>db.searchDocumentWithSpecialCharactersDemo.insertOne({"UserId":"Taylor$Carol983","UserFirstName":"Carol","UserLastName":"Taylor"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5c987bdb330fd0aa0d2fe4b2")
}
>db.searchDocumentWithSpecialCharactersDemo.insertOne({"UserId":"Doe$John999","UserFirstName":"John","UserLastName":"Doe"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5c987bee330fd0aa0d2fe4b3")
}
>db.searchDocumentWithSpecialCharactersDemo.insertOne({"UserId":"Miller$David555","UserFirstName":"David","UserLastName":"Miller"});
{
"acknowledged" : true,
"insertedId" : ObjectId("5c987c01330fd0aa0d2fe4b4")
}Following is the query to display all documents from a collection with the help of find() method
> db.searchDocumentWithSpecialCharactersDemo.find().pretty();
This will produce the following output
{
"_id" : ObjectId("5c987b98330fd0aa0d2fe4b1"),
"UserId" : "Smith$John123",
"UserFirstName" : "John",
"UserLastName" : "Smith"
}
{
"_id" : ObjectId("5c987bdb330fd0aa0d2fe4b2"),
"UserId" : "Taylor$Carol983",
"UserFirstName" : "Carol",
"UserLastName" : "Taylor"
}
{
"_id" : ObjectId("5c987bee330fd0aa0d2fe4b3"),
"UserId" : "Doe$John999",
"UserFirstName" : "John",
"UserLastName" : "Doe"
}
{
"_id" : ObjectId("5c987c01330fd0aa0d2fe4b4"),
"UserId" : "Miller$David555",
"UserFirstName" : "David",
"UserLastName" : "Miller"
}Following is the query to search string with special characters in a MongoDB document. Here, we are searching for a string John with special character $
> db.searchDocumentWithSpecialCharactersDemo.find({ UserId : /.*\$John.*/i }).pretty();This will produce the following output:
{
"_id" : ObjectId("5c987b98330fd0aa0d2fe4b1"),
"UserId" : "Smith$John123",
"UserFirstName" : "John",
"UserLastName" : "Smith"
}
{
"_id" : ObjectId("5c987bee330fd0aa0d2fe4b3"),
"UserId" : "Doe$John999",
"UserFirstName" : "John",
"UserLastName" : "Doe"
}
Updated on: 30-Jul-2019
1K+ Views
Advertisements