From: Johan De Meersman Date: November 3 2011 10:23am Subject: Re: Removing Double Quotes List-Archive: http://lists.mysql.com/mysql/226220 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Adarsh Sharma" > > 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