Jul24
MySQL – Replace Select Text within a Database Field
on July 24th, 2009 at 5:02 am
Maintaining databases can be a chore, but knowing the appropriate SQL to do the job can save hours of time. Here is a tidbit regarding changing a select string of text within a specific field of a table in a MySQL database. You can edit 1000s of records with this one query:
UPDATE table SET field = REPLACE(field, 'text to be replaced', 'replacement text');
In this example, the table name is “table”, the field to find the text in is named “field”, the rest should be self explanatory.
Stumble Upon
Del.icio.us
Buzz
viral marketing is of course the best way to market products on the internet`-*