Hacker

Unlocking the Power of JSON in MySQL: Tips and Tricks

JSON data type was first introduced in MySQL 5.7.8 in August 2015. It was quite a while ago, but I still see many people using the TEXT data type to store JSON data. In this article, I will explain ...
Hacker

The Secret to Faster JSON Queries in MySQL: Generated Columns

Your browser does not support the audio element. Ran into a situation where I had a table with loads and loads of records that included a meta JSON column, ideally ...
GitHub

README.md

Description: Learn how to use MySQL JSON_SEARCH() to find the path of a string value within a JSON document, supporting both first-match and all-match modes with wildcard patterns. JSON_SEARCH() ...
linuxiac

MySQL 9.0 Released: What’s New, Changed, and Removed

One of MySQL 9.0’s headline features is the advanced handling of JSON data. Users can now save JSON output from EXPLAIN ANALYZE commands directly into a user variable. This feature, available under ...