MySQL Forums
Forum List  »  InnoDB

not getting with JSON data
Posted by: Ra Nala
Date: September 21, 2017 04:29AM

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
not getting with JSON data
1002
September 21, 2017 04:29AM
571
September 22, 2017 09:10AM
564
September 26, 2017 05:38AM
552
September 26, 2017 10:10AM


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.