From: Rick James
Date: August 1 2012 9:18pm
Subject: RE: how to replace this data in a complex field?
List-Archive: http://lists.mysql.com/mysql/227930
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB1489DB9D84@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

SW4gb3RoZXIgd29yZHMsIHRoaXMgbWlnaHQgd29yaz8/DQoNClVQREFURSBUYWJsZTEgU0VUIA0K
ICBJbnZlbnRvcnkgPSBSRVBMQUNFKEludmVudG9yeSwgJyJBQ1JFX1BSQzExOV9JRF8yOSInLCAn
IkFDUkVfUFJDMTE5IicpOw0KDQpOb3RlOiB0aGUgZXh0cmEgcXVvdGVzIHdlcmUgZGVsaWJlcmF0
ZS4NCg0KSWYgaXQgaXMgbm90IGFsd2F5cyBJRF8yOSwgdGhlbiB0aGUgcHJvYmxlbSBpcyBtb3Jl
IGRpZmZpY3VsdC4NCg0KDQo+IC0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQo+IEZyb206IEpv
aGFuIERlIE1lZXJzbWFuIFttYWlsdG86dmVnaXZhbXBAdHV4ZXJhLmJlXQ0KPiBTZW50OiBUdWVz
ZGF5LCBKdWx5IDMxLCAyMDEyIDE6MzkgQU0NCj4gVG86IEluY2FydXMgRGVycA0KPiBDYzogbXlz
cWxAbGlzdHMubXlzcWwuY29tDQo+IFN1YmplY3Q6IFJlOiBob3cgdG8gcmVwbGFjZSB0aGlzIGRh
dGEgaW4gYSBjb21wbGV4IGZpZWxkPw0KPiANCj4gDQo+IA0KPiAtLS0tLSBPcmlnaW5hbCBNZXNz
YWdlIC0tLS0tDQo+ID4gRnJvbTogIkluY2FydXMgRGVycCIgPGljYXJ1c2RlcnBAZ21haWwuY29t
Pg0KPiA+DQo+ID4gSSBoYXZlIGEgY29tcGxleCBmaWVsZCBuYW1lZCBJbnZlbnRvcnkgaW4gYSB0
YWJsZSBuYW1lZCBUYWJsZTEgdGhhdA0KPiA+IGNhbiBiZSBkaWZmZXJlbnQgZXZlcnkgdGltZSBh
bmQgaXMgbm90IGd1YXJhbnRlZWQgdG8gY29udGFpbiB3aGF0IEkNCj4gPiBuZWVkIHRvIHJlcGxh
Y2UuDQo+ID4NCj4gPg0KPiBbWyJUaGluZzEiLCJUaGluZzQiLCJ0aGluZzgiLCJ0aGluZzEiLCJ0
aGluZzk0MiIsIkFDUkVfUFJDMTE5X0lEXzI5Il0sDQo+ID4gW1sidGhpbmcxNzAwIiwyXSwiZGF0
dGhpbmc0IiwicGl6emEiLCJ3YXRlciIsImFwcGxlcywiYmVhbnMiLCJjb2tlLWEtDQo+IGMNCj4g
Pg0KPiBvbGEiLCJyaWNlIiwiYXBwbGVzIiwiYXBwbGVzIiwiaWNlY3JlYW0iLCJwaXp6YSIsWyI3
dGhpbmdzIiw2XSwiN3RoaW5nDQo+ID4gcyIsIjd0aGluZ3MiLCI4dGhpbmdzIiwidG9waGF0cyIs
InRvcGhhdHMiLCI3NjJ4MzltbVJVIl1dDQo+IA0KPiBUaGF0IGxvb2tzIG1vcmUgbGlrZSBhIG11
bHRpZGltZW5zaW9uYWwgYXJyYXkgdGhhbiBhIHRhYmxlLCB0byBtZS4NCj4gDQo+ID4NCj4gPiBJ
IG5lZWQgdG8gcmVwbGFjZSBBQ1JFX1BSQzExOV9JRF8yOSB3aXRoIEFDUkVfUFJDMTE5IGFuZCBJ
IGNhbm5vdCBkbw0KPiA+IHRoaXMgZXh0ZXJuYWxseS4gSSBoYXZlIFBSRUdfUkVQTEFDRSBidXQg
SSdtIG5vdCBzdXJlIGhvdyBJIHdvdWxkDQo+ID4gYXBwbHkgdGhpcyB0byB0aGUgZGF0YWJhc2Ug
YmVjYXVzZSBpdCBvbmx5IFNFTEVDVCdzIGFzIGZhciBhcyBJIGtub3cuDQo+IA0KPiAuLi5hbmQg
cHJlZ19yZXBsYWNlIGlzIGEgUEhQIGZ1bmN0aW9uLCBub3QgYSBNeVNRTCBvbmUuIEFyZSB5b3Ug
c3VyZQ0KPiB5b3UncmUgb24gdGhlIHJpZ2h0IGxpc3Q/DQo+IA0KPiBJbiBhbnkgY2FzZSwgaWYg
eW91J3JlIGxvb2tpbmcgdG8gZG8gdGhpcyBpbiBNeVNRTCwgdGhpcyBpcyB0aGUNCj4gZnVuY3Rp
b24geW91J3JlIHByb2JhYmx5IGdvaW5nIHRvIGJlIHVzaW5nOg0KPiBodHRwOi8vZGV2Lm15c3Fs
LmNvbS9kb2MvcmVmbWFuLzUuMC9lbi9zdHJpbmctDQo+IGZ1bmN0aW9ucy5odG1sI2Z1bmN0aW9u
X3JlcGxhY2UNCj4gDQo+IElmIHlvdSdyZSBsb29raW5nIHRvIGRvIHRob3NlIHN1YnN0aXR1dGlv
bnMgb24gYW4gbWRhcnJheSBpbiBQSFAsIHdlbGwsDQo+IHdyb25nIGxpc3QgOi0pIEknbGwgaGlu
dCB5b3UgdGhhdCB5b3UncmUgcHJvYmFibHkgZ29pbmcgdG8gaGF2ZSB0bw0KPiB3cml0ZSBhIHJl
Y3Vyc2l2ZSBmdW5jdGlvbiwgdGhvdWdoLCBpZiB5b3VyIG1kYXJyYXkgaGFzIHZhcnlpbmcgZGVw
dGguDQo+IA0KPiANCj4gLS0NCj4gTGludXggQmllciBXYW5kZXJ1bmcgMjAxMiwgbm93IGFsc28g
YXZhaWxhYmxlIGluIEJlbGdpdW0hDQo+IEF1Z3VzdCwgMTIgdG8gMTksIERpa3NtdWlkZSwgQmVs
Z2l1bSAtIGh0dHA6Ly9sYncyMDEyLnR1eGVyYS5iZQ0KPiANCj4gLS0NCj4gTXlTUUwgR2VuZXJh
bCBNYWlsaW5nIExpc3QNCj4gRm9yIGxpc3QgYXJjaGl2ZXM6IGh0dHA6Ly9saXN0cy5teXNxbC5j
b20vbXlzcWwNCj4gVG8gdW5zdWJzY3JpYmU6ICAgIGh0dHA6Ly9saXN0cy5teXNxbC5jb20vbXlz
cWwNCg0K