CodeIgniter Forums
How to query Json objects in MySQL? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: General (https://forum.codeigniter.com/forumdisplay.php?fid=1)
+--- Forum: Lounge (https://forum.codeigniter.com/forumdisplay.php?fid=3)
+--- Thread: How to query Json objects in MySQL? (/showthread.php?tid=86009)



How to query Json objects in MySQL? - InsiteFX - 01-01-2023

How to query Json objects in MySQL?


RE: How to query Json objects in MySQL? - superior - 01-02-2023

Interesting, i'll be needing this for a project, thank you for sharing!


RE: How to query Json objects in MySQL? - Sprint - 01-23-2023

That's an informative project. There is no native way to query JSON objects in MySQL. You can make use of the MySQL JSON_EXTRACT() function to extract values from a JSON object, but the syntax is complex. Alternatively, you can use a third-party library such as jOOQ or Hibernate to query the JSON object.


RE: How to query Json objects in MySQL? - leusiam - 02-01-2023

oh i thought it was a question you asked
well thanks for that.