Sizetrac

MySQL Find & Replace

This is a good "oh shit" tool... It's just a simple way to do a search and replace across all values in a column. It will replace every occurrence in the column so use with caution...

UPDATE `table` SET `column` = REPLACE(`column`, ‘find’, ‘REPLACE)

  • Digg
  • TwitThis
  • del.icio.us
  • Netvouz
  • description
  • Reddit
  • Furl
  • NewsVine
  • Simpy
  • Slashdot
  • Spurl
  • StumbleUpon
  • YahooMyWeb
  • TailRank
  • Technorati
  • Facebook
  • Google
  • LinkedIn
  • Live
  • MySpace
  • Ping.fm
  • Yahoo! Buzz
  • E-mail this story to a friend!



Home | MySQL | MySQL Find & Replace