Reports

Check out a userscript which highlights deleted posts. GitHub

79382505

Date: 2025-01-23 20:41:00

Score: 0.5

Natty:

With some REPLACE in 1.2.3.4 to get [1,2,3,4] you can simply use JSON_EXTRACT:

SELECT
  JSON_EXTRACT(ip.column1, '$[0]'),
  JSON_EXTRACT(ip.column1, '$[1]'),
  JSON_EXTRACT(ip.column1, '$[2]'),
  JSON_EXTRACT(ip.column1, '$[3]')
FROM (
  VALUES('[1,2,3,4]')
) AS ip

Reasons:

Low length (0.5):
Has code block (-0.5):
Low reputation (0.5):

Posted by: yotheguitou