If you have MySQL version >= 5.7, then you can try this: SELECT JSON_EXTRACT(name, "$.id") AS name FROM table WHERE JSON_EXTRACT(name, ...
確定! 回上一頁