mongodb custom sorting like mysql

Question

I am trying to sort a field, but I need to do it like how mysql does and specify the value,

instead of field number sory by -1, 4 3 2 1.

I need to sort it by 2,1,3,4.

is this possible in mongodb?

Amit Phaltankar · Accepted Answer · 2018-03-06 02:33:22Z

1

This is not possible in MongoDB. MongoDB doesn't know which and how many fields exist in a particular document unless the document is retrieved. Hence MongoDB practically cannot give numbers to specific fields.

MongoDB is a JSON-style data store. The documents stored in the database can have varying sets of fields, with different types for each field.

In Databases the number and types of the column is fixed by particular table definition and it's easier for a database system to give numbers to the columns.

answered Mar 6, 2018 at 2:33

Amit Phaltankar

3,4242 gold badges26 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

mongodb custom sorting like mysql

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