skip to Main Content

Extracting python list values in MYSQL

I have a column in MySQL database which contains a python list of json formatted values like below: Column [{"name":"me","color":"red"} , {"name":"you","color":"blue"}] I could not use json_extract() function because it's not formatted exactly as a json I want to extract…

VIEW QUESTION
Back To Top
Search