Single quotes issue with JSON data

[Ra Nala]

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.