I’m looking for a way to do this in SingleStore:
I have a column with coma separated string that I need to split to different rows and the join to the table as a new column
sql server script:
SELECT id,
product_ids,
value new_col
FROM platform.manual_rule
CROSS APPLY STRING_SPLIT(product_ids, ',')
thank you,
I tried but I got this error massage (I also try with string split()) :
ERROR 1054 ER_BAD_FIELD_ERROR: Unknown column ‘value’ in ‘field list’