Mongodb Text Index | Full Text Search in MongoDB

Welcome to the MongoDB Video Series and in this video, I'm talking about Text Index in MongoDB which enables the text based search within MongoDB

text searches are often complicated and slow, but is an integral part of most of the production level software. In a production quality software most of the text bases searches are done on the data already stored in a database and mongodb enables the same using the Text Indexes

In this video I've used MongoDB Compass to explain the concept and usage behind the text index so that everyone watching this video can understand the same no matter which programming languages they work on. I've also explained the concept of aggregation framework and how we can use the text lookingup in mongodb using $lookup in aggregation framework.

I've also talked about number of text indexes we can create and the limitations around the same.

I do hope and belive that this video will be helpful to all of you

Timecodes

0:00 : Text Index in MongoDB
1:09 : Purpose of text Indexes
1:47 : Sample Data for text index
2:51 : Normal text search in MongoDB
4:13 : Creating a Text Index in MongoDB Compass
4:55 : Searching using Text Index $text and $search in MongoDB
5:35 : Text search on complete word
5:54 : Text Search using OR & AND
6:53 : Scoring the text search result in MongoDB
9:02 : Case sensitive support in MongoDB
10:06 : Text Index on more than one field

#mongodb #textindex #database #seach

About Me i.e. An Insightful Techie

Greetings and Thanks a lot for checking out my YouTube Channel. I’m Deepak K Gupta (Daksh). This channel is a medium for me to share my learnings and journey as a Techie so that you not only learn from my experience but also from my mistakes

As a techie I am closely associated with software development, so most of my content will revolve around Programming Languages, AI, Machine learning and Databases. I share things which will help you learn, remember and use these things in an effective and efficient way.

As a Techie, I also know that there is a life beyond software development and it has a profound impact on our career as well as on our well being. I also share those learnings which I feel are worth sharing with the intention that it MAY help you in taking better decisions in your life.

Last but not the least, I'm a traveler and explorer by nature. I would like to take you with me on some of the interesting journeys around the world. Believe me there is more to learn outdoors than indoors

Hope you’ll like my contents and will be part of my journey 🙏

[james]

I can not express how much I appreciate this video. Spent several hours trying to figure this out and in one 11 minute video I've gone from no progress to complete solution. Thank you

[research]

Nice video. Loved the honesty while declaring disclaimer.

[mubinjonzokirov]

Excellent video! Helped me just at the right time! Thank you!

[RichardAnderssonDeffe]

Perfect education video, I was looking for exactly this with good examples.

[prasathj]

I am glad to came across this video as this is exactly what I have been looking for. Very clear explanation. Thanks a lot. I would like to know how search works across horizontal scaling in MongoDB if the DB is partitioned.

[varshasingh]

If I want to do text search using incomplete text like obj, how can we do this?

[GurdeepSingh-grfb]

excellent video sir, covered my every doubt.

[gauravarora]

sir in this you didn't even mention the field description.. so how does it find it in that particular field?

[crazyvedh]

Thank you very much.helped me on right time

Good video besides I would not call it Full Text when we don`t have n-grams and fuzzy words/matching since you are running MongoDb locally.

[KerimGarnett]

Nice video, thanks a lot for the tutorial. So if I understand correctly, index search doesn't provide something like "like" operator. If the half of the word is given, then it doesn't return anything. For example: searching "ti" for the word "title". The alternative way is using regexes and doing a normal search but it decreases the performance. So is there a way where I can search for a meaningless text and get the full word efficiently with or without using indexes?

[Xcoderclub]

Which MongoDB Compass version you are using?

[tiavina-mika]

thanks. can you mlake a video about search index with MongoDB Atlas?

[hazemabdelalim]

You can create only one text index, but you can make it compound text index