try replace() http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replace
UPDATE Category SET Cat_Name = replace(Cat_Name,'®',‘™’) WHERE Cat_Name LIKE ‘%®%’; 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. Ben Johansen http://www.webspinr.com [email protected] Phone: 360-597-3372 Mobile: 360-600-7775 ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
