Thats going to replace the entire field with ‘™’. So if the field 'Text ® Some Product', you query will change it to just '™' You are either going to have to create a more sophisticated regex query, or write a program or script to loop through and do this.
-- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 15520 Coutelenc Rd Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [email protected] - [email protected] http://bighead.net/ - http://eventpix.com/ On Feb 8, 2011, at 1:55 PM, Fogelson, Steve wrote: > Hi, > > Database is MySQL. Having a brain fart today. I want to update all > occurrences of ® to ™ in a field, but leave the rest of the field > intact. > > I believe this would set the filed to ™ > > UPDATE Category SET Cat_Name = ‘™’ WHERE Cat_Name LIKE ‘%®%’; > > Thanks > > Steve Fogelson > > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
