I have a table which contains a username column which may be constructed something like
somename[AAAAA] or [BBBBCCCCDDD]someothername The AAAAA or BBBBCCCCDDD can be anything at all. I've added a new column to the table to which I'd like to populate with the value within the square brackets. I could write something in perl or php to run through each and update them but was wondering if there is a way to do this within mysql itself? The regexp only returns a boolean so I can't see how to use that. Regards Phil -- Distributed Computing stats http://stats.free-dc.org