MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

-- single value
SELECT *
FROM JSON_TABLE(
  JSON_ARRAY('00351615'),
  "$[*]"
  COLUMNS(
    ids BIGINT(20) PATH "$"
  )
) AS tt;

-- multiple values
SELECT *
FROM JSON_TABLE(
  JSON_ARRAY('00351615', '12345678'),
  "$[*]"
  COLUMNS(
    ids BIGINT(20) PATH "$"
  )
) AS tt;


ids


351615




ids


351615

12345678


-- single value
SELECT *
FROM JSON_TABLE(
  CONCAT('[', '"00351615"', ']'),
  "$[*]"
  COLUMNS(
    ids BIGINT(20) PATH "$"
  )
) AS tt;

-- multiple values
SELECT *
FROM JSON_TABLE(
  CONCAT('[', '"00351615","12345678"', ']'),
  "$[*]"
  COLUMNS(
    ids BIGINT(20) PATH "$"
  )
) AS tt;


ids


351615




ids


351615

12345678


SELECT JSON_VALID(CONCAT('[', '00351615', ']'))


JSON_VALID(CONCAT('[', '00351615', ']'))


0