In MariaDB, ASCII() is a built-in string function that returns the numeric ASCII value of the leftmost character of its string argument.
The ASCII() function only works on 8 bit characters. To get the code for multi-byte characters, use the ORD() function instead.
Here’s how to install MariaDB on a Mac via the Homebrew package manager.
Continue readingIn MongoDB, the cursor.sort() method specifies the order in which the query returns matching documents.
The sort() method accepts a document that specifies the field to sort, and the sort order. The sort order can be either 1 for ascending or -1 for descending.
You can also specify { $meta: "textScore" } when doing $text searches, in order to sort by the computed textScore metadata in descending order.
In MongoDB, the $orderBy query modifier sorts the results of a query in ascending or descending order.
$orderBy accepts a document that specifies the field to sort, and the sort order. The sort order can be either 1 for ascending or -1 for descending.
$orderBy has been deprecated in the mongo shell since v3.2. Use the cursor.sort() method instead.
In MongoDB, the $sort aggregation pipeline stage sorts all input documents and returns them to the pipeline in sorted order.
In MongoDB, the $switch aggregation pipeline operator evaluates a series of case expressions, and executes a specified expression only when a case expression evaluates to true.
MongoDB provides a few operators that enable you to remove values from arrays.
These include:
$pull$pullAll$popIn MongoDB, the $mergeObjects aggregation pipeline operator combines multiple documents into a single document.
If you have a collection of documents in MongoDB that contain arrays, you can add new values to those arrays if required.
Depending on your specific requirements, you can use the $push operator or the $addToSet operator.
In MongoDB you can use the $isArray aggregation pipeline operator to check whether or not a value is an array.
It accepts any valid expression, and returns true if the expression is an array, false if it’s not.