How to get particular column value from Json Data in Mysql

 

JSON Data:

{"source_request_id":"FD6108C1-04AE-A0DF-8817-4C0BF0CE37E1","appl_no":"1579141","emp_code":"2452353","response_code":422,"response_desc":"INVAILD EMP CODE 2452353"}

Query:

Using JSON_EXTRACT method we can achive:

SELECT response_code AS sync_response_code,JSON_EXTRACT(emlap_response, '$.response_desc') As sync_response_msg FROM table_name WHERE lead_id = 1579141;

Expected Output: "INVAILD EMP CODE 2452353"