- Original Message -
> From: "Adarsh Sharma"
> UPDATE website_master SET url= REPLACE( url,'"','');
Yep, that works fine, too, on condition that there are no quotes in the middle
of your value that need to remain where they are :-)
--
Bier met grenadyn
Is als mosterd by den wyn
Sy
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"
I need to remove the quotes in text columns in a mysql table. It has
You could go w
On 11/3/2011 02:29, Adarsh Sharma wrote:
Dear all,
I need to remove the quotes in text columns in a mysql table. It has
more than 5000 rows.
In some rows there is values quoted with ". I want to remove them.
Below is the snapshot :
*ID /URL Country Publication / Description ...and so o
- 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
upda
Dear all,
I need to remove the quotes in text columns in a mysql table. It has
more than 5000 rows.
In some rows there is values quoted with ". I want to remove them.
Below is the snapshot :
*ID /URL
Country
