If you have MySQL 5.7.13 or later, you may use JSON_UNQUOTE() instead of JSON_EXTRACT() or ->> instead of -> . Example: SELECT field->>"$.foo.barr" FROM ...
確定! 回上一頁