Thanks Johan,
I solved the problem by the below command :-
UPDATE website_master SET url= REPLACE( url,'"','');
Thanks
Johan De Meersman wrote:
> ----- Original Message -----
>
>> From: "Adarsh Sharma" <adarsh.sharma@stripped>
>>
>> I need to remove the quotes in text columns in a mysql table. It has
>>
>
> You could go with regexes - s/^"(.*)"$/&1/ should do (in whatever syntax is
> appropriate for the parser you're using); or you could go with something similar to
>
> update table foo set bar = substring(bar, 2, length(bar)-2) where bar like '"%"';
>
> I'm too lazy to look up the exact syntaxes, but this is pretty straightforward
> stuff.
>
>
