Mongodb like statement with array

Question

I am trying to save some db action by compiling a looped bit of code with a single query, Before I was simply adding to the the like statements using a loop before firing off the query but i cant get the same idea going in Mongo, id appreciate any ideas.... I am basically trying to do a like, but with the value as an array

('app', replaces 'mongodb' down to my CI setup )

Here's how I was doing it pre mongofication:

    foreach ($workids as $workid):
         $this->ci->app->or_like('work',$workid)    ;
    endforeach;
    $query = $this->ci->db->get("who_users");
    $results = $query->result();
    print_r($results);

and this is how I was hoping I could get it to work, but no joy here, that function is only designed to accept strings

    $query = $this->ci->app->like('work',$workids,'.',TRUE,TRUE)->get("who_users");
    print_r($query);

If anyone can think of a way any cunning methods I can get my returned array with a single call again it would be great I've not found any documentation on this sort of query, The only way i can think of is to loop over the query and push it into a new results array.... but that is really gonna hurt if my app scales up.

I wonder is it possible that I can do a where_in with wildcards somehow — IndelibleHeff
– IndelibleHeff, Commented May 23, 2012 at 0:35
What kind of query are you trying to run against MongoDB? I don't quite understand that from your question above. — Derick
– Derick, Commented May 23, 2012 at 9:22
well im checking if an id is in a field of listed ids so basically something like - get rows where ids contain $id, I am doing this now with foreach ($workids as $workid): $html .= "\r\n friendsbox[".$workid."] ='';"; $this->ci->app->like('workids',$workid,'im',TRUE,TRUE); endforeach; $query = $this->ci->app->get("who_users"); But that only returns the last query i need a way to do it over an array really. , or more importantly a way to chain them I think. — IndelibleHeff
– IndelibleHeff, Commented May 23, 2012 at 18:03
also the variable would be something like 08478498657659 and the rows in the table have fields i am searching through with the LIKE statement have contents like "90840974074,3988752852,2986387548764, 39868529864" — IndelibleHeff
– IndelibleHeff, Commented May 23, 2012 at 18:08

jmikola · Accepted Answer · 2012-05-23 18:42:32Z

1

Are you using codeigniter-mongodb-library? Based on the existing or_like() documentation, it looks like CI wraps each match with % wildcards. The equivalent query in Mongo would be a series of regex matches in an $or clause:

db.who_users.find({
    $or: [
    { work: /.*workIdA.*/ },
    { work: /.*workIdB.*/ },
    ...
]});

Unfortunately, this is going to be quite inefficient unless (1) the work field is indexed and (2) your regexes are anchored with some constant value (e.g. /^workId.*/). This is described in more detail in Mongo's regex documentation.

Based on your comments to the OP, it looks like you're storing multiple ID's in the work field as a comma-delimited string. To take advantage of Mongo's schema, you should model this as an array of strings. Thereafter, when you query on the work field, Mongo will consider all values in the array (documented discussed here).

db.who_users.find({
    work: "workIdA"
});

This query would match a record whose work value was ["workIdA", "workIdB"]. And if we need to search for one of a set of ID's (taking this back to your OR query), we can extend this example with the $in operator:

db.who_users.find({
    work: { $in: ["workIdA", "workIdB", ...] }
});

If that meets your needs, be sure to index the work field as well.

edited May 23, 2012 at 18:42

answered May 23, 2012 at 18:35

jmikola

6,9222 gold badges33 silver badges66 bronze badges

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

2 Comments

IndelibleHeff Over a year ago

yes you are right, I have recently converted to the Code igniter MongoDB library, and that would be better structured in the new environment - Looks like I'll need to build a function in the library to try and deal with the mulitple clauses.

jmikola Over a year ago

Are you sure a new method is necessary? I haven't worked with the library, but where_in() looks like what you'd need.

Collectives™ on Stack Overflow

Mongodb like statement with array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related