Re: Single quotes issue with JSON data
What's the result you get for this part of your query?
select
(replace(replace(replace(CAST(JSON_EXTRACT(fd.f_d_data,'$.sectionGroups[*].sections[*].label.code') as CHAR),'[',''),']',''),'"','''')) as label_code
from v_f vf
left join v_i fi on fi.id=vf.v_i_id
left join f_d fd on fd.id=fi.f_d_id
where vf.id=133
--
Alfredo Kojima
MySQL Developer Tools
Subject
Views
Written By
Posted
1475
September 21, 2017 04:27AM
781
October 01, 2017 02:27AM
737
October 03, 2017 01:07AM
Re: Single quotes issue with JSON data
772
December 01, 2017 01:25AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.