-- 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

• Instead of MySQL's IFNULL function, this works on PostgreSQL, Sqlite and others too
• 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