PHP MongoDB按字母顺序排序结果

Question

I'm sure this is really simple to do, but how do you sort by alphabetical (preferably a natural sort) in mongo w/ PHP? This is what I have right now:

$data->sort(array('title' => 1));

And it's not returning the array in alphabetical order. Am I missing something?!

Answer 1

I am new to mongodb. But from what I understand about it is that less work should be done in mongodb and more work should be done in application. Its why mongodb can hit high speeds, simply because it is not trying to be an application its self like an RDMS. I think you will need to index the collection tho. just use ensureIndex(array('title' => 1));