Quote:
Originally Posted by sarettah
If you do that then you also have to have a way to put that back into the database, I assume.
If you are doing all occurrences of a certain word within a table/field than you can do it with a sql update either at the mysql command line or through something like phpmyadmin.
update tablename set field=replace(field,'string_to_replace','string_to _replace_with')
always check yourself first by doing a select using the same syntax to make sure your results will be what you want them to be. Then do a copy of the table before you do the update, just to be 100% sure.
select field, replace(field,'string_2_replace','string_to_replac e_with') from tablename
.
|
this is the best way, but make sure you have a backup if you do that, and triple check everything, one wrong move and your whole "field" could get set to null...
