Mongodb like query with two fields is not working(with php)

Question

I am writing a script to fetch data from two fields but not working. Below is my code

$cursor = $collection->find(
    array('$text' => array('$search' => 'रेजिमेंट')),
    array('score' => array('$meta' => 'textScore'))
);

I checked some forum but not helping me.

How to query MongoDB with "like"? (this is not working and also this have only one field "name" while I required search with two fields.)

Where $text is the index set for two fields title and description.If anyone have idea please share me.

can you show all your indexes, or atleast your text index. ?Just wanna be sure there is no problem with your indices — Ravi Shankar Bharti, Jul 09 '19 at 12:28
@RaviShankarBharti, indexes are "name" : "description_text_title_text" .these are working fine with exact match but I am trying to search with match case. — akgola, Jul 09 '19 at 12:31
can you run the same query in your mongodb shell and confirm if its working? — Ravi Shankar Bharti, Jul 09 '19 at 12:34
@RaviShankarBharti,I am new in Mongo db ,can you please write query for me as per my requirement? — akgola, Jul 09 '19 at 12:38
you can try : `db.collection_name.find({$text : {$search : 'रेजिमेंट'}})` in your mongo shell, and see if it works in your shell — Ravi Shankar Bharti, Jul 09 '19 at 12:43
@RaviShankarBharti,I got error Error: error: { "ok" : 0, "errmsg" : "text index required for $text query (no such collection 'rss_master.collection_name')", "code" : 27, "codeName" : "IndexNotFound" } — akgola, Jul 09 '19 at 12:45
it looks like you dont have a text index, thats why it is showing this error. — Ravi Shankar Bharti, Jul 09 '19 at 12:46
@RaviShankarBharti, { "v" : 2, "key" : { "_id" : 1 }, "name" : "_id_", "ns" : "ms_master.vp_stu_details" }, { "v" : 2, "key" : { "_fts" : "text", "_ftsx" : 1 }, "name" : "description_text_title_text", "ns" : "ms_master.vp_stu_details", "weights" : { "description" : 1, "title" : 1 }, "default_language" : "english", "language_override" : "language", "textIndexVersion" : 3 } — akgola, Jul 09 '19 at 12:48
@RaviShankarBharti,but exact search is working fine.As you can check indexes in earlier comments. — akgola, Jul 09 '19 at 12:51
i think you need to add language support in the index as well. — Ravi Shankar Bharti, Jul 09 '19 at 12:55
looks like there is no support for hindi language in text search index yet — Ravi Shankar Bharti, Jul 09 '19 at 13:00
did you replace `collection_name` with actual collection name in the query i gave you to run in mongo shell? It looks like, you just copy pasted my code. Please try with your actual collection name — Ravi Shankar Bharti, Jul 09 '19 at 13:01
oh yes you are correct error is not occured but nothing result.. — akgola, Jul 09 '19 at 13:04
since nothing is returned in shell, nothing will come back in your php code as well — Ravi Shankar Bharti, Jul 09 '19 at 13:05
@RaviShankarBharti,so why result is not coming?Please help me. — akgola, Jul 09 '19 at 13:06
i dont think i can properly answer that, it totally depends on your database collection. And it might be also because of the language issue. — Ravi Shankar Bharti, Jul 09 '19 at 13:09
@RaviShankarBharti,but exact phrase is working fine .can you please advice how to write like query with two column? — akgola, Jul 09 '19 at 13:12
two columns are title and description where from I want to write query and search particular word? — akgola, Jul 09 '19 at 13:30

Mongodb like query with two fields is not working(with php)

0 Answers0