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, ',')