mysql query that splits string for an Insert?

Question

I got a customers table with this column: hashtag VARCHAR(255), that contains lowercase words separated by white spaces.

We added a new table:

hashtag ( id INT, tag VARCHAR(255) )

I need to take each customer's hashtag string, split it, and insert it in the hashtag table if it doesn't exists.

I'd really prefer to do everything SQL only and write php if it's inevitable.

Does MySQL permit to split a string column at each occurrence of a certain char and use the resulting words to execute an insert?

I think your question has been answered [elsewhere](https://stackoverflow.com/a/17043084/12859753) — Bill Jetzer, Jun 25 '20 at 14:13

score 0 · Answer 1 · edited Apr 19 '22 at 07:12

0

INSERT INTO hashtag
            (tag)
SELECT *
FROM   String_split ((SELECT hashtag
                      FROM   customers), ' ')

edited Apr 19 '22 at 07:12

RF1991

answered Jun 27 '20 at 08:42

1 Answers1