Maarten's Posterous

Internet Development

« Back to posts
  • Viewed
    times
September 23, 2009

Find & Replace in MySQL

  • Edit
  • Delete
  • Tags
  • Autopost

To find and replace in a MySQL database, use the following SQL statement:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

Source: http://www.mediacollege.com/computer/database/mysql/find-replace.html

Tweet
  • 0 responses
  • Like
  • Comment