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 (
(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
left join f_d fd on

Could you please help me.

Options: ReplyQuote

Written By
not getting with JSON data
September 21, 2017 04:29AM
September 22, 2017 09:10AM
September 26, 2017 05:38AM
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.