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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
