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...

PLAIN TEXT
SQL:
  1. UPDATE `table` SET `column` = REPLACE(`column`, ‘find’, ‘REPLACE’)

These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • del.icio.us
  • Netvouz
  • DZone
  • Reddit
  • Furl
  • NewsVine
  • Simpy
  • Slashdot
  • Spurl
  • StumbleUpon
  • YahooMyWeb
  • TailRank
Home | MySQL | MySQL Find & Replace

You’re currently reading “ MySQL Find & Replace ,” an entry on BRADINO

Published:
3.24.07 / 9am
Category:
MySQL