Single quotes issue with JSON data
Posted by: Ra Nala
Date: September 21, 2017 04:27AM

Hi ,

We are using MySQL InnoDB 5.7.11 version and not able to get results when i pass info which i am getting data for 1st query results.

Query 1:

select * from app_l where label_code in ('237644111', '1712436829', '189005040')

I will get results ('237644111', '1712436829', '189005040') for below sub query but not getting results from table even though i have data in table : app_l

Query 2:

select * from app_l where label_code in (
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
)

Could you please help me.

Options: ReplyQuote


Subject
Views
Written By
Posted
Single quotes issue with JSON data
649
September 21, 2017 04:27AM
399
October 03, 2017 01:07AM


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.