Search comma separated values in MongoDB using PHP with comma separated input values

Question

How to search comma separated values in MongoDB using PHP with comma separated input values?

Ex: In collection1 I am storing the values with comma separated and now I want to search that column with comma separated values:

{service_list: 'a, b, c'}

Now I want to search that field with (a,d,e).

If we store in array we can search easily but there is no chance to change the DB structure. How can I solve this issue?

Did you try something like that db.collection1.find({"service_list": /.*a.*.d.*/}) — Ahmad Rezk
– Ahmad Rezk, Commented Mar 23, 2017 at 9:36
Thanks for your reply, I have tried just now it's not getting all matched documents — Madhu Ch
– Madhu Ch, Commented Mar 23, 2017 at 10:01
You really need to change that DB structure. The long-term downside of sticking with a bad database design will outweight the short-term pain of rectifying the structure. — Vince Bowdren
– Vince Bowdren, Commented Mar 23, 2017 at 19:10

Muhammad Shahzad · Accepted Answer · 2017-05-04 05:40:07Z

0

You can use $regex

<?php

$m = new MongoClient();
$db = $m->selectDB('test');
$collection = new MongoCollection($db, 'phpmanual');

$cursor = $collection->find(
 array('service_list' => array('$regex' => 'something'))
);

?>

answered May 4, 2017 at 5:40

Muhammad Shahzad

9,68022 gold badges90 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Search comma separated values in MongoDB using PHP with comma separated input values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related