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 UA-cam 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 🙏
SUBSCRIBE - ua-cam.com/users/AnInsightfulT...
INSTAGRAM - www.intagram.com/AnInsightful...
Twitter - / awisetechie
Facebook - / aninsightfultechie

[@james2353]

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

[@Cognitive-Programmer]

Thank you so much for your kind words..Thanks a lot 🙏

[@mubinjonzokirov3292]

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

[@Cognitive-Programmer]

Thanks a lot for your comment 🙏

[@RichardAnderssonDeffe]

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

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@research8098]

Nice video. Loved the honesty while declaring disclaimer.

[@Cognitive-Programmer]

Thanks you so much for your comment 🙏

[@MyAndr1]

Perfect explanation! Thank you!!!!

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@tomasgalmarini5203]

Thanks so much, this helps me a lot!

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@prasathj7436]

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.

[@Cognitive-Programmer]

Thanks a lot for your valuable comment. I will see if I can create a video on the question you've asked. Thanks again 🙏

[@jayeshshimpi1332]

Love it... 🔥

[@crazyvedh4489]

Thank you very much.helped me on right time

[@Cognitive-Programmer]

thanks for your comment

[@GurdeepSingh-gr7fb]

excellent video sir, covered my every doubt.

[@Cognitive-Programmer]

Glad to hear that.. Thanks a lot for your comment 🙏

[@accident_video_509]

thank you sir for this video

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@Javedboqo1]

Explained in a great way

[@Cognitive-Programmer]

Thanks a lot 🙏

[@saiprasaadk3145]

Thank you sir !

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@dashiellbark-huss6806]

This was so well explained

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@varshasingh1299]

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

[@akiraigarashi2874]

Thanks a lot

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@MohammadBarghamadii]

Thank you so much

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@achmadjulian741]

Thanks sir

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@gauravarora5865]

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

[@KerimGarnett1]

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?

[@Cognitive-Programmer]

Thanks for your comment..
Your understanding is right… text indexes are created for complete word.. you need to used regex for like or partial text search.
Hope it helps.. Thanks 🙏

[@KerimGarnett1]

@@Cognitive-Programmer yes Sir it helped, you made it very clear for me, because I was searching that solution for hours. thanks a lot 🙏

[@shreyashachoudhary480]

Amazing

[@Cognitive-Programmer]

Thanks a lot for your comment 🙏

[@alaintouloucanon5467]

thank you

[@Cognitive-Programmer]

Thanks for your comment 🙏

[@machavarapugowtham6787]

How do we access nested data

[@abhaynarnaware6162]

Can I search for a number as well?

[@msbasera]

We need more videos on mongoDB

[@Cognitive-Programmer]

🙏

[@Caelghoul]

what if field $text not in root !?

[@Xcoderclub]

Which MongoDB Compass version you are using?

[@Cognitive-Programmer]

Version 1.30.1 🙏

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.

[@tiavina-mika]

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

[@Cognitive-Programmer]

Thanks for your valuable suggestion.. 🙏 at this moment of time atlas is not in the backlog but things may change in the future

[@hazemabdelalim5432]

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