Hello friends, I have a table named named "sample" in my mysql database. Sample table contains a column named "content". I have around 1000 records in the table. All 1000 records contains a text "for more visit http://mynameisgiri.blogspot.com " in the end. I want change this into "for more visit http://www.viruthagiri.com " in all 1000 records. Is there any tool available to change this?. Or can anyone give me mysql query to do that?. Please help me. Thanks
No need guys. i found it in this page. thanks. http://www.mydigitallife.info/2007/04/23/how-to-find-and-replace-text-in-mysql-database-using-sql/