How to search text in MongoDB

2 次查看（过去 30 天）
Thomas Dufresne
Thomas Dufresne 2020-2-27
编辑： Ralf Elsas 2020-4-7
MongoDB allows you search for a word in the database
db.articles.find( { $text: { $search: "coffee" } } )
There doesn't seem to be an equivalent in matlab's interface to MongoDB.
Any thoughts on how to search for a string in the database?

请先登录，再回答此问题。

回答（1 个）

Nipun Katyal
Nipun Katyal 2020-3-3
Make sure you have a proper installation of MongoDB and the corresponding support packages in matlab
To connect to an existing database here is the link to the documentation
https://www.mathworks.com/help/database/ug/database-toolbox-interface-for-mongodb-installation.html
https://www.mathworks.com/help/database/ug/mongo.html
To connect to an existing database
server = "dbtb01";
port = 27017;
dbname = "mongotest";
conn = mongo(server,port,dbname)
To execute a search query
collection = "employee";
mongoquery = '{"department":"Sales"}';
documents = find(conn,collection,'Query',mongoquery);
  4 个评论
显示 2更早的评论
Thomas Dufresne
Thomas Dufresne 2020-3-6
Thanks for your response. I was hoping to find a way that can actually search the database first for the occurrence of a text string, as opposed to pulling everything into matlab and then searching for a text string within a structure. It appears that MongoDB can search for a string within the database, but that not feature is not available in the matlab implementation.
Ralf Elsas
Ralf Elsas 2020-4-7
编辑：Ralf Elsas 2020-4-7
Hi, I was just bothering with the same problem.
A solution I have found is to use the $regex command in the find function:
mongoquery = '{"label": {$regex: "pay"}}'
finds all documents where the text variable "label" contains "pay", using find(conn,collection,'Query',mongoquery).
Hope this helps.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by