{"id":48269,"date":"2019-01-30T13:00:41","date_gmt":"2019-01-30T07:30:41","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=48269"},"modified":"2021-05-09T13:07:22","modified_gmt":"2021-05-09T07:37:22","slug":"mongodb-text-search","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/","title":{"rendered":"MongoDB Text Search\u00a0– Indexing Single & Multiple Fields"},"content":{"rendered":"
In our last tutorial, we had learned about Executing MongoDB in Java Program<\/strong>. Now, we will be looking at MongoDB Text Search.<\/div>\n
<\/div>\n
In this article, we will study how to index mongoDB text search partial, multiple fields, and entire document. Along with this, we will learn the different languages supported by the text search.<\/div>\n

MongoDB Text Search<\/h2>\n

We can perform MongoDB text search of string content with the help of query operations.\u00a0$text operator <\/strong>is used to perform\u00a0this kind of text search in MongoDB.<\/p>\n

To understand this topic in a better manner we will be using an example of a collection<\/strong> named as examples with the following structure.<\/div>\n
<\/div>\n
\n
{\r\n\"subject\":\"Joe\",\u00a0\r\n\"content\":\"best friend\",\u00a0\r\n\"likes\": 60,\u00a0\r\n\"year\":2015,\u00a0\r\n\"language\":\"english\"\r\n}<\/pre>\n
Let\u2019s add some sample documents in the collection.<\/p>\n<\/div>\n
\n
db.examples.insert({\"subject\":\"Joe\", \"content\":\"best friend\", \"likes\": 60, \"year\":2015, \"language\":\"english\"})\r\n\r\ndb.examples.insert({\"subject\":\"Dogs\", \"content\":\"Cats\", \"likes\": 30, \"year\":2015, \"language\":\"english\"})\r\n\r\ndb.examples.insert({\"subject\":\"Cats\", \"content\":\"Rats\", \"likes\": 55, \"year\":2014, \"language\":\"english\"})\r\n\r\ndb.examples.insert({\"subject\":\"Rats\", \"content\":\"Joe\", \"likes\": 75, \"year\":2014, \"language\":\"english\"})<\/pre>\n
i. Indexing a Single Field<\/strong><\/h3>\n<\/div>\n
Here, we will create a text index<\/strong> on the subject field of our document using the query given below:<\/div>\n
<\/div>\n
\n
db.examples.createIndex({\"subject\":\"text\"})<\/pre>\n
Now, if you want to test this newly created text index on the subject field, we will have to find documents using $text operator. We will look for all documents that have keyword dog in their subject field.<\/p>\n<\/div>\n
\n
db.examples.find({$text: {$search: \"dogs\"}}, {score: {$meta: \"toextScore\"}}).sort({score:{$meta:\"textScore\"}})<\/pre>\n
Here, we are using {$meta: \u201ctextScore\u201d } to get some statistics about how relevant our resultant document is. After that, we will sort all documents by their textScore using sort command. Higher the textScore, more relevant the match is.<\/p>\n<\/div>\n
The output for the following code will be like this:<\/strong><\/div>\n
<\/div>\n
{ “_id” : ObjectId(“55f4a5d9b592880356441e94”), “subject” : “Dogs”, “content” : “Cats”, “likes” : 30, “year” : 2015, “language” : “english”, “score” : 0.66 }<\/div>\n
<\/div>\n
Here the document is having a score as 0.66 as the word dog appeared only once.<\/div>\n
ii. Indexing Multiple Fields<\/h3>\n
In our real-time scenarios, we will have to use MongoDB text search on multiple fields of a document. In our example to understand this, we will enable compound text indexing on the subject and content fields.<\/div>\n
<\/div>\n
But before doing this we will have to drop the existing text index as it can take only one text index per collection.<\/div>\n
<\/div>\n
\n
db.examples.dropIndex(\"subject_text\")\u00a0\r\ndb.examples.createIndex({\"subject\":\"text\",\"content\":\"text\"})<\/pre>\n
After writing this query now write another query to find out all documents with keyword cat.<\/p>\n<\/div>\n
\n
db.messages.find({$text: {$search: \"cat\"}}, {score: {$meta: \"textScore\"}}).sort({score:{$meta:\"textScore\"}})<\/pre>\n
This query will give us the following output:<\/strong><\/p>\n<\/div>\n
{ “_id” : ObjectId(“55f4af22b592880356441ea4”), “subject” : “Dogs”, “content” : “Cats”, “likes” : 30, “year” : 2015, “language” : “english”, “score” : 0.6666 }<\/div>\n
<\/div>\n
{ “_id” : ObjectId(“55f4af22b592880356441ea5”), “subject” : “Cats”, “content” : “Rats”, “likes” : 55, “year” : 2014, “language” : “english”, “score” : 0.6666 }<\/div>\n
iii. Indexing the Entire Document<\/h3>\n
Suppose, if we want to do indexing for all mails stored in MongoDB. For that, we will have to take into consideration sender, recipient, subject and body also using $** wildcard specifier.<\/div>\n
<\/div>\n
Now we will look at the example to understand it better:<\/div>\n
\n
db.messages.createIndex({\"$**\":\"text\"})<\/pre>\n
This query will set up text indexes on any string fields in our documents. For this insert a new document with a new field location in it.<\/p>\n<\/div>\n
\n
db.examples.insert({\"subject\":\"Birds\", \"content\":\"Rats\", \"likes\": 12, \"year\":2013, location: \"Switzerland\", \"language\":\"english\"})<\/pre>\n
Now if we try to search with Switzerland keyword then it will show up the current document we inserted.<\/p>\n<\/div>\n
\n
db.examples.find({$text: {$search: \"switzerland\"}}, {score: {$meta: \"textScore\"}}).sort({score:{$meta:\"textScore\"}})\r\n<\/pre>\n<\/div>\n
iv. Languages Supported\u00a0by Text Search by MongoDB<\/h3>\n
A new version is introduced by MongoDB,\u00a0version 2 for the text search features. Version 1 only supports the long form of each language name. But in version, we can use two-letter language codes defined in ISO 639-1.<\/p>\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Language Name<\/strong><\/td>\nTwo-Letter Code<\/strong><\/td>\n<\/tr>\n
Danish<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0da<\/td>\n<\/tr>\n
English<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0en<\/td>\n<\/tr>\n
Dutch<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0nl<\/td>\n<\/tr>\n
Finnish<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0fi<\/td>\n<\/tr>\n
French<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0fr<\/td>\n<\/tr>\n
German<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0de<\/td>\n<\/tr>\n
Hungarian<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0hu<\/td>\n<\/tr>\n
Italian<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0it<\/td>\n<\/tr>\n
Norwegian<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0nb<\/td>\n<\/tr>\n
Portuguese<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0pt<\/td>\n<\/tr>\n
Romanian<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0ro<\/td>\n<\/tr>\n
Russian<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0ru<\/td>\n<\/tr>\n
Spanish<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0es<\/td>\n<\/tr>\n
Swedish<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0sv<\/td>\n<\/tr>\n
Turkish<\/td>\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0tr<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
So, this was all about MongoDB Text Search Tutorial. Hope, you like our explanation.<\/p>\n
Summary<\/h2>\n
Hence, we have studied about text search in MongoDB<\/strong> with different scenarios to be searched from an example.<\/div>\n
<\/div>\n
In addition, we had discussed all the supported languages by MongoDB Text Search with ISO 639-1 code. Furthermore, if you have any query, feel free to share with us. Surely, we will get back to you.<\/div>\n","protected":false},"excerpt":{"rendered":"
In our last tutorial, we had learned about Executing MongoDB in Java Program. Now, we will be looking at MongoDB Text Search. In this article, we will study how to index mongoDB text search...<\/p>\n","protected":false},"author":6,"featured_media":48287,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[18614,18615,18616],"class_list":["post-48269","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mongodb","tag-mongodb-text-search","tag-mongodb-text-search-tutorial","tag-text-search-in-mongodb"],"yoast_head":"\nMongoDB Text Search\u00a0- Indexing Single & Multiple Fields - DataFlair<\/title>\n<meta name=\"description\" content=\"MongoDB Text Search Tutorial - How to index a single field, Multiple Fields, an entire document, supported languages by Text search in MongoDB\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MongoDB Text Search\u00a0- Indexing Single & Multiple Fields - DataFlair\" \/>\n<meta property=\"og:description\" content=\"MongoDB Text Search Tutorial - How to index a single field, Multiple Fields, an entire document, supported languages by Text search in MongoDB\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-30T07:30:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-09T07:37:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/MongoDB-Text-Search-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MongoDB Text Search\u00a0- Indexing Single & Multiple Fields - DataFlair","description":"MongoDB Text Search Tutorial - How to index a single field, Multiple Fields, an entire document, supported languages by Text search in MongoDB","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/","og_locale":"en_US","og_type":"article","og_title":"MongoDB Text Search\u00a0- Indexing Single & Multiple Fields - DataFlair","og_description":"MongoDB Text Search Tutorial - How to index a single field, Multiple Fields, an entire document, supported languages by Text search in MongoDB","og_url":"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-01-30T07:30:41+00:00","article_modified_time":"2021-05-09T07:37:22+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/MongoDB-Text-Search-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"MongoDB Text Search\u00a0– Indexing Single & Multiple Fields","datePublished":"2019-01-30T07:30:41+00:00","dateModified":"2021-05-09T07:37:22+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/"},"wordCount":625,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/MongoDB-Text-Search-01.jpg","keywords":["MongoDB Text Search","MongoDB Text Search Tutorial","Text Search in MongoDB"],"articleSection":["MongoDB Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/mongodb-text-search\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/","url":"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/","name":"MongoDB Text Search\u00a0- Indexing Single & Multiple Fields - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/MongoDB-Text-Search-01.jpg","datePublished":"2019-01-30T07:30:41+00:00","dateModified":"2021-05-09T07:37:22+00:00","description":"MongoDB Text Search Tutorial - How to index a single field, Multiple Fields, an entire document, supported languages by Text search in MongoDB","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/mongodb-text-search\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/MongoDB-Text-Search-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/01\/MongoDB-Text-Search-01.jpg","width":1200,"height":628,"caption":"MongoDB Text Search\u00a0- Indexing Single, Multiple Fields & Entire Document"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/mongodb-text-search\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"MongoDB Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/mongodb\/"},{"@type":"ListItem","position":3,"name":"MongoDB Text Search\u00a0– Indexing Single & Multiple Fields"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/48269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=48269"}],"version-history":[{"count":7,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/48269\/revisions"}],"predecessor-version":[{"id":93183,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/48269\/revisions\/93183"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/48287"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=48269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=48269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=48269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}