如何从MySql中提取JSON

Question

我想从下面的JSON中提取新的状态值

{"old_status":"Testing(PhaseI)","new_status":"Production(PhaseII)","user":"Developer","reason":null}

所以需要的输出是Production(PhaseII)请注意，new_status的值是完全动态的，如何使用JSON_EXTRACT()

Answer 1

SELECT JSON_UNQUOTE(JSON_EXTRACT(`field``, '$.new_status'))