----- 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. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
