In MariaDB, the modulo operator (%) returns the modulo operation. It returns the remainder of its first argument divided by its second argument.
Tag: operators
How to Format the Date in MongoDB
If you have documents that store dates as Date objects, but you want to return them in a different format, you can use the $dateToString aggregate pipeline operator.
For example, you might want a date to be returned in mm/dd/yyyy format instead of the long ISODate() format that includes minutes, seconds, milliseconds, etc
The $dateToString operator converts the Date object to a string, and optionally allows you to specify a format for the resulting output.
How the LIKE Operator Works in MariaDB
In MariaDB, the LIKE operator allows you to do pattern matching. It determines whether a specific character string matches a specified pattern. It returns either 1 (TRUE) or 0 (FALSE).
How NOT LIKE Works in MariaDB
In MariaDB, the NOT LIKE operator is used to test whether or not a string does not match a pattern. It returns the inverse of the LIKE operator. It’s the same as applying the NOT operator against the whole LIKE expression.
How the BINARY Operator Works in MariaDB
In MariaDB, the BINARY operator casts the string following it to a binary string.
The BINARY operator enables you to do a column comparison byte by byte rather than character by character. This causes the comparison to be case sensitive even if the column isn’t defined as BINARY or BLOB. It also means that leading/trailing spaces become significant.
MongoDB $sort
In MongoDB, the $sort aggregation pipeline stage sorts all input documents and returns them to the pipeline in sorted order.
MongoDB $switch
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 $mergeObjects
In MongoDB, the $mergeObjects aggregation pipeline operator combines multiple documents into a single document.
MongoDB $isArray
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.
MongoDB $literal
In MongoDB, the $literal aggregation pipeline operator returns a value without parsing.
It accepts any valid expression, and returns the unparsed expression.
The $literal operator can be useful for when you have a value that MongoDB could inadvertently interpret as an expression, but you don’t want it to.
For example, if you have a monetary amount that includes a dollar sign, MongoDB might inadvertently interpret that as a field name. You can use $literal to prevent MongoDB from interpreting such expressions.