Hi i have data in a mysql table which is about 70000 rows. In one column there is information that I would like to split into 2 rows. The information I want to send over to the other named row is nicely sat in brackets eg (18) . It is imperative whilst i move these over to the new named row that they stay aligned with the same row, as the information will be all wrong if not.
EG - i need to move the (18) and (24) over to colomn 4 and delete from column 2 the (18) and (24)
Colomn 1 Colomn 2 Colomn 3 Colomn 4
row 1 xxxxxx xxx (18) xxxxxxx
row 2 xxxxxx xxx (18) xxxxxxx
row 3 xxxxxx xxx (24) xxxxxxx
row 4 xxxxxx xxx (18) xxxxxxx
What code would I need to run to enable me to do this.
Thanks for your help