更新时间:2023-01-29 16:41:35
您可以使用json_extract
(5.7或更高版本).
https://dev.mysql.com /doc/refman/5.7/en/json-search-functions.html#function_json-extract
You could use json_extract
(5.7 up).
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html#function_json-extract
SELECT user_id, json_data
FROM articles
WHERE json_extract(json_data, '$.title') LIKE '%CPU%';