79083367

Date: 2024-10-13 14:27:17
Score: 1.5
Natty:
Report link

This works with any sanitized comma separated values.

SET @values = '1,Smith,3';
SELECT * from JSON_TABLE(CONCAT('["', REPLACE(@values, ',', '","'), '"]'),
                  '$[*]' COLUMNS (yourcolumn_name TEXT PATH '$')) jsontable;

query results in rows

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: lisandro