1.json字符串格式
{"themeColor": "#9225EF", "isShareGetOneChance": 1}
方式1:
SELECT json_unquote(json_extract(config_data,'$.themeColor'))
FROM mj_marketing_tool_activity_info
WHERE is_delete = 0 and json_extract(config_data,'$.themeColor') = '#9225EF';
方式2:
SELECT config_data ->'$.themeColor'
FROM mj_marketing_tool_activity_info
WHERE is_delete = 0 and config_data ->'$.themeColor' = '#9225EF';
其中:
json_extract():根据key取出对应的value(),如果value有双引号,则取出的数据也有;
json_unquote():去除value字符串的引号