From: Johan De Meersman
Date: November 3 2011 11:44am
Subject: Re: Removing Double Quotes
List-Archive: http://lists.mysql.com/mysql/226223
Message-Id: <19f4d486-7211-4820-9a9d-921fd496f758@zimbra>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="=_519e3002-eba0-452c-98d6-1151d2f9d2eb"

--=_519e3002-eba0-452c-98d6-1151d2f9d2eb
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

----- Original Message -----

> From: "Adarsh Sharma" <adarsh.sharma@stripped>

> UPDATE website_master SET url= REPLACE( url,'"','');

Yep, that works fine, too, on condition that there are no quotes in the middle of your value that need to remain where they are :-) 

-- 
Bier met grenadyn 
Is als mosterd by den wyn 
Sy die't drinkt, is eene kwezel 
Hy die't drinkt, is ras een ezel 

--=_519e3002-eba0-452c-98d6-1151d2f9d2eb--