To replace particular string with
another in mysql use the following command
update tablename set field =
replace(field,’search_for_this’,'replace_with_this’);
24th Jul, 2007
Replace particular string with another in mysql
Leave a response
Categories and Tags
Add new tag
ads
bike riding
bug fixes
funs
games
god
installations
Java
javascripts
jokes
lessons
Linux
love
Mac OS
morals
Most Expected
MySQL
Networking
outings
programming
ruby
Ruby on Rails
Scriptures
songs
tips
Trips
Videos
windows Amazed at…. (3)
C,FastCGI (2)
Found it useful (2)
Fun-and-morals (83)
installations (12)
Java (4)
Javascript (3)
Lessons I have learnt (16)
Misc (1)
Most Expected (1)
MySQL (6)
Networking (1)
Photos (1)
Rails - Mac Leopard (9)
Rails deployment–FCGI (1)
Rails deployment–SCGI (1)
Ruby on Rails (65)
Scriptures (12)
Trips (1)
Unix (2)
Videos (29)
Weird Errors (25)
WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.