mysql json字段查询

mysql 获取json数组中的某些字段的值

原始数据

select line.name as 线路名称,liner_plan.liner_code as 班次号,liner_plan.departure_time as 发车时间,
         json_extract(liner_plan.way_points ,'$[*].alias','$[*].name') as 途径
from liner_plan LEFT JOIN line on liner_plan.line_id = line.id where liner_plan.`status`='run' and  line.owner_id=197;

# 获取json数组中的alias,name的值        
 json_extract(liner_plan.way_points ,'$[*].alias','$[*].name') as 途径

查询后的数据