Windows or Linux?? The REPLACE() function would do it if using the Character Mapping in Windows.
UPDATE tbl_Name SET col1 = REPLACE(col1,'"','"') UPDATE tbl_Name SET col1 = REPLACE(col1,'"','"') They are ALT+0147 and ALT+0148 in Windows Character Map (charmap.exe) J.R. -----Original Message----- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Monday, December 05, 2005 2:13 PM To: mysql@lists.mysql.com Subject: Killing my curly quotes OK, I'm bad - I have curly quotes in my db that I failed to eliminate prior to the insert. Now that they're in there, is there a way to replace them with straight quotes? Everything I try fails to find them. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]