Convert Data To New Field

[AndyPanda]

My MySQL looks something like this..
id int
name text
description text

The descrption data will look something like this:
This is the descrption (234), The end.

What I want to do is take the data between the () and create a new field in the database call tag. I want to do this for each entry, and there is a LOT.

Therefore my database would be
id int
name text
description text
tag text

What I want to know is, how do I get the data between the ( ) in php? Then loop this in a mysql query.

Thank you

[Bjom]

if you can make absolutely sure there is only one instance of those parantheses (parentheses?) then you can even do it w/o the loop and instead use one SQL query like so:

UPDATE myTable SET `tag` = MID(`description`,LOCATE('(',`description`) +1,LOCATE(')',`description`) - LOCATE('(',`description`)-1)

[AndyPanda]

THank you Bjom