Re: Single quotes issue with JSON data
Posted by: Alfredo Kojima
Date: December 01, 2017 01:25AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
980
September 21, 2017 04:27AM
524
October 03, 2017 01:07AM
Re: Single quotes issue with JSON data
557
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.