Re: Removing Double Quotes

[Adarsh Sharma]

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.sha...@orkash.com>

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.