inal Message-
> From: Johan De Meersman [mailto:vegiv...@tuxera.be]
> Sent: Tuesday, July 31, 2012 1:39 AM
> To: Incarus Derp
> Cc: mysql@lists.mysql.com
> Subject: Re: how to replace this data in a complex field?
>
>
>
> - Original Message -
> > From: &qu
- Original Message -
> From: "Incarus Derp"
>
> I have a complex field named Inventory in a table named Table1 that
> can be different every time and is not guaranteed to contain what I need to
> replace.
>
> [["Thing1","Thing4","thing8","thing1","thing942","ACRE_PRC119_ID_29"],[["thin
On 07/31/2012 09:07 AM, Incarus Derp wrote:
I need to replace ACRE_PRC119_ID_29 with ACRE_PRC119 and I cannot do this
externally. I have PREG_REPLACE but I'm not sure how I would apply this to
the database because it only SELECT's as far as I know.
You could CREATE a TABLE from the SELECT.
Isn'