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