If you need to only check, whether the json key exists, you can use JSON_CONTAINS_PATH. I expect it to be faster than JSON_EXTRACT. mySQL 8.0 docs. Example:.
確定！ 回上一頁
