I have a table which contains a username column which may be constructed
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.
Distributed Computing stats