-- tested with MySQL 5.7, MariaDB 10.2

SELECT JSON_EXTRACT(json_format, '$.name') as jname, JSON_EXTRACT(json_format, '$.status') as jstatus
  FROM history LIMIT 5

• Getting row counts of different columns in one query in MySQL
• How to make MySQL using an index only by adding "order by"
• Window Function - an old SQL standard that is now available in MySQL

PHP 8.2, Laminas MVC 3.2, Symfony 5.2, Laravel 8.28, PHPUnit 9.5, Doctrine ORM 2.8