List:General Discussion« Previous MessageNext Message »
From:Adarsh Sharma Date:November 3 2011 6:29am
Subject:Removing Double Quotes
View as plain text  
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

Thread
Removing Double QuotesAdarsh Sharma3 Nov
  • Re: Removing Double QuotesJohan De Meersman3 Nov
    • Re: Removing Double QuotesAdarsh Sharma3 Nov
      • Re: Removing Double QuotesJohan De Meersman3 Nov
  • Re: Removing Double QuotesMySQL)3 Nov