----- 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.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
