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
