List:General Discussion« Previous MessageNext Message »
From:Incarus Derp Date:July 31 2012 6:07am
Subject:how to replace this data in a complex field?
View as plain text  
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"],[["thing1700",2],"datthing4","pizza","water","apples,"beans","coke-a-cola","rice","apples","apples","icecream","pizza",["7things",6],"7things","7things","8things","tophats","tophats","762x39mmRU"]]

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.


              Any solutions?
                -Ikarus

Thread
how to replace this data in a complex field?Incarus Derp31 Jul
  • Re: how to replace this data in a complex field?Mihamina Rakotomandimby31 Jul
  • Re: how to replace this data in a complex field?Johan De Meersman31 Jul
    • RE: how to replace this data in a complex field?Rick James1 Aug