RE: Witango-Talk: Differences between Standard and Advanced Server?

What database are you using? Chuck Lockwood President http://www.lockdata.com/pics/ld_logo.jpg (P) 570.226.7340 www.lockdata.com And please, Follow

Witango-Talk: Looking for a little SQL help (OT)

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 --

Re: Witango-Talk: Looking for a little SQL help (OT)

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

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_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 u

RE: Witango-Talk: Looking for a little SQL help (OT)

Looks like what I am looking for. I will test it out. Thanks Ben _ From: Ben Johansen [mailto:b...@webspinr.com] Sent: Tuesday, February 08, 2011 4:17 PM To: Witango-Talk@witango.com Subject: Re: Witango-Talk: Looking for a little SQL help (OT) try replace() http://dev.mysql.co

RE: Witango-Talk: Looking for a little SQL help (OT)

Hi Ben, I received this error when running the following *Error: 1175 SQLSTATE: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column UPDATE Products SET P_Name = REPLACE(P_Name,'FISH-FRY M

Re: Witango-Talk: Looking for a little SQL help (OT)

Error: 1175 SQLSTATE: HY000 (ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE) Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column This error denotes that UPDATE conflicts with the safe mode setting as set in the MySQL daemon. To fix, edit your .cnf f