Order by MySQL JSON field
18 August 2023 (Updated 27 April 2025)
SELECT * FROM products order by products.details->"$.city_name" DESC
Tagged:
SQL recipes
SELECT * FROM products order by products.details->"$.city_name" DESC