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 on*
2474 http://www.times-standard.com/ United States
Times-Standard California 1 2009-10-22 10:34:39 T
F 7546609 0 T F T
T T
2475 http://www.argentinastar.com/ Argentina Argentina Star
1 0000-00-00 00:00:00 0 0 0
0
2476 "http://www.economist.com/countries/argentina/";
"Argentina" "Economist " "The site gives research tools to
search articles by subjects and backgrounds. DD in the date tag is
written in the following format : 3rd for 3 2 0000-00-00
00:00:00 0 0 0 "N"
0
2477 "http://www.ambito.com/english/"; "Argentina"
"Ambito.Com" "The date tage show on the right side main page
0 0000-00-00 00:00:00 T 0 0 0
"N" 0
2570 "http://en.apa.az/"; "Apa" 1 0000-00-00
00:00:00 0 0 0
0
2571 "http://www.theazeritimes.com/"; "Caspian " "The Azeri
Times" "last update on 18 Feb 2011" 1 0000-00-00
00:00:00 0 0 0
0
Please let me know the efficient & easiest way to remove it.
Thanks
