In MySQL, the BIT_OR() function returns the bitwise OR of all bits in a given expression.
Category: MySQL
Understanding the BIT_AND() Function in MySQL
In MySQL, the BIT_AND() function returns the bitwise AND of all bits in a given expression.
10 Functions that Modify JSON Values in MySQL
MySQL provides us with a bunch of functions that can modify JSON values. Here are ten functions that we can use to modify JSON values in MySQL.
Continue reading6 Ways to Extract JSON Data in MySQL
In MySQL, we have several options when it comes to extracting data from JSON documents. Below are six methods we can use to do this.
Continue reading7 Functions that Create JSON Values in MySQL
MySQL includes some inbuilt functions that can be used to create JSON values, such as JSON arrays, JSON objects, or a quoted string literal.
Here are seven functions that allow us to create JSON values in MySQL.
Continue readingMySQL JSON Functions & Operators
Below is a list of the JSON functions and operators available in MySQL.
Continue reading3 Ways to Unquote a JSON Value in MySQL
In MySQL, we have several options when it comes to removing the quotes from a JSON value.
For example, normally if we return a string value from a JSON document, we would get that value along with its quotes. But sometimes we might not want the quotes. Below are three methods we can use to unquote a JSON value in MySQL.
Continue readingUnderstanding the JSON_SCHEMA_VALIDATION_REPORT() Function in MySQL
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.
7 Functions to Format a Number to 2 Decimal Places in MySQL
A common task when working with numbers is to format them to a certain amount of decimal places. Two decimal places seems to be the most common format, but we can format to any number of decimal places we want. MySQL provides us with a number of functions that can help us achieve this.
Below are seven functions that can be used to format a number to two decimal places in MySQL.
Continue readingHow JSON_SCHEMA_VALID() Works in MySQL
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.