If the bracketed stuff really can be anything, you're better off doing it
externally, I guess. If you can be reasonably sure that there'll not be any
square brackets in there, you can fluff about with instr() and substr().
On Sat, Jan 22, 2011 at 6:18 PM, Eric Bergen <eric.bergen@stripped> wrote:
> There isn't a built in way but you can try
> I would go with the php/perl script if this is a one time thing.
> On Jan 21, 2011, at 11:31 AM, Phil <pchapman@stripped> wrote:
> > 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
> > value within the square brackets.
> > I could write something in perl or php to run through each and update
> > 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
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel