List:General Discussion« Previous MessageNext Message »
From:Shawn Green (MySQL) Date:November 3 2011 11:09am
Subject:Re: Removing Double Quotes
View as plain text  
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 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
>

The manual is your friend, please don't be afraid to use it. I believe 
the function you are looking for is REPLACE().

http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_replace

-- 
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
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