Looks like what I am looking for. I will test it out.
Thanks Ben _____ From: Ben Johansen [mailto:[email protected]] Sent: Tuesday, February 08, 2011 4:17 PM To: [email protected] Subject: Re: Witango-Talk: Looking for a little SQL help (OT) try replace() http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replac e <http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_repla ce> 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] <mailto:[email protected]> with "unsubscribe witango-talk" in the body. Ben Johansen http://www.webspinr.com <http://www.webspinr.com> [email protected] <mailto:[email protected]> Phone: 360-597-3372 Mobile: 360-600-7775 _____ To unsubscribe from this list, please send an email to [email protected] <mailto:[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.
