SELECT
record_id,
record_json -> '$."name"' AS 姓名,
record_json -> '$."age"' AS 年龄,
record_json -> '$."fname"' AS 家长姓名,
record_json -> '$."phone"' AS 家长手机号,
record_json -> '$."wkind"' AS 作品种类,
record_json -> '$."wname"' AS 作品名称,
record_json -> '$."gender"' AS 性别,
record_json -> '$."company"' AS 送评单位,
record_json -> '$."teacherphone"' AS 指导老师手机号,
create_time AS 创建时间
FROM
activity_records
WHERE
activity_id = 1653732181302