CREATE TABLE TEST (
ID CHAR(3),
STRING VARCHAR(100)
)Table created.
INSERT INTO TEST VALUES ('Id1','Thing1: Sub1, <br>Thing2: Sub7 ,Sub8 , Sub9 <br>Thing3: Sub12')1 row(s) inserted.
INSERT INTO TEST VALUES ('Id1','Thing2: Sub6, Sub7, Sub8, <br>Thing3: Sub12 ,Sub13')1 row(s) inserted.
INSERT INTO TEST VALUES ('Id1','Thing1: Sub1, Sub2 <br>Thing2: Sub7 ,Sub8 , Sub9 <br>Thing3: Sub12')1 row(s) inserted.
INSERT INTO TEST VALUES ('Id2','Thing1: Sub2, Sub3 <br>Thing2: Sub7 <br>Thing3: Sub13')1 row(s) inserted.
INSERT INTO TEST VALUES ('Id3','Thing2: Sub7')1 row(s) inserted.