mysql json将字符串替换为整数

Question

如何将 JSON 中的所有值从字符串替换为整数？

+-----------------------------------+ 
| video_related                     |
+-----------------------------------+ 
| ["8626416", "8457156", "8605962"] |
+-----------------------------------+

Change to:
+-----------------------------------+ 
| video_related                     |
+-----------------------------------+ 
| [8626416, 8457156, 8605962]       |
+-----------------------------------+

Answer 1

您可以使用CONVERT:

SELECT stuff
FROM table
WHERE conditions
ORDER BY CONVERT(name_column, SIGNED INTEGER);