Query.all ("name", "a", "B"), or//through multiple elements to match the array query.and (QUERY.EQ ("name", "a"), Query.eq ("title", "T"));// Simultaneously satisfies multiple conditions query.eq ("name", "a");//Equals query.exists ("type", true);//Determines whether the key value exists QUERY.GT ("value", 2);//Greater Than > query.gte ("value", 3);//greater than or equal to >= query.in ("name", "a", "B"); /Includes all values specified, you can specify different types of conditions and values query.lt ("value", 9);//Less than < query.lte ("value", 8);//less than or equal to <= query.mod ("Value", 3, 1);//Divide the query value by the first given value, and return the result if the remainder equals the second given value query.ne ("name", "C");//Not equal to query.nor (array);//does not include the value in the array query.not ("name");//Element condition statement query.notin ("name", "a ", 2);//Returns a document that does not match all the conditions in the array query.or (QUERY.EQ (" name "," a "), Query.eq (" title "," T "), and/or satisfies one of the conditions query.size ("name", 2);//The length of the given key query.type ("_id", bsontype.objectid);//The type of the given key Query.where (bsonjavascript);//Execute Javascript query.matches ("Title", str);//fuzzy query corresponds to like in SQL-- STR can contain regular expressions
MongoDB official C # driver query criteria for querying usage