MySQL json 数据的提取。

SELECT 
    s.id,u.user_name,t.category_name, JSON_UNQUOTE ( t.category_name -> '$.cn' ) as cn
FROM
    mydb3.user_info AS u
        INNER JOIN
    mydb3.user_shop AS s
        INNER JOIN
    mydb3.t_shop_category AS t ON u.id = s.user_id
        AND u.category_id = t.category_id
			where  t.category_name -> '$.cn' = '牛肉';

简言 : JSON_UNQUOTE(表.字段名 -> '$.key)