In MySQL, the STD() function returns the population standard deviation of a given expression.
STD() is a synonym for the standard SQL function STDDEV_POP(). There’s also a STDDEV() function which also does the same thing, so we can use either of these functions to get the same result.
In MySQL, the BIT_XOR() function returns the bitwise XOR of all bits in a given expression.
XOR is an exclusive OR, and so a XOR b is mathematically equal to (a AND (NOT b)) OR ((NOT a) and b).
In MySQL, the BIT_OR() function returns the bitwise OR of all bits in a given expression.
In MySQL, the BIT_AND() function returns the bitwise AND of all bits in a given expression.
In MySQL, the JSON_SCHEMA_VALIDATION_REPORT() function validates a JSON document against a JSON schema and returns a report of the outcome of that validation. The report is returned as a JSON document.
If the document is valid, only one field is returned: "valid" : true. If the document is not valid, a more extensive report is provided.
In MySQL, the JSON_SCHEMA_VALID() function validates a JSON document against a JSON schema. It returns true (1) if the document is valid, and false (0) if it is not.
In MySQL, we can use the ->> operator to extract a value from a JSON document, and unquote that value.
We provide the column that contains the JSON document to the left of the operator, and the path to the value that we want to extract to the right.
The ->> operator is equivalent to JSON_UNQUOTE(JSON_EXTRACT()), and it provides the same results.
In MySQL, we can use the -> operator to extract data from a JSON document.
We provide the column that contains the JSON document to the left of the operator, and the path to the value that we want to extract to the right.
The -> operator is an alias for the two-argument form of the JSON_EXTRACT() function.
In MySQL, the MEMBER OF() operator tests whether or not a value is a member of a given JSON array.
It returns true (1) if the array contains the value, and false (0) if it doesn’t.
The MEMBER OF() operator was added in MySQL 8.0.17.
In MySQL, JSON_OVERLAPS() is a function that tests whether or not two JSON documents have any key-value pairs or array elements in common.
The function returns true (1) if the documents have any key-value pairs or array elements in common, and false (0) if they don’t.
The JSON_OVERLAPS() function was added in MySQL 8.0.17.