SELECT * from test WHERE JSON_CONTAINS(`value`, ‘3‘,‘$‘);
SELECT JSON_LENGTH(`value`,‘$‘) from test
Mysql Json操作
原文:https://www.cnblogs.com/huisunan/p/15196014.html