MongoDB Database, order by a field which is a string field but with a number in it

I have a MongoDB and I nee开发者_C百科d to order by a field (id), but this field is a string field with a number in it.

Example:

   {
     "_id": ObjectId("4e60f8c2b1638e5479c8ba6f"),
     "id": "3188",
     "type": "P"
   }

The id field with value "3188" I need to order on that field as if it's an integer. Has MongoDB got some magic that it can do this?

Thanks!

Magick of mongodb not enough to sort string as integer ;)

So there is only one solution is to make int field from string field and sort on it.