View Single Post
Old 11-27-2012, 03:28 PM  
sarettah
see you later, I'm gone
 
Industry Role:
Join Date: Oct 2002
Posts: 14,075
Quote:
Originally Posted by lakerslive View Post
download .sql and open in dreamweaver then do copy and replace word? tnx
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

.
__________________
All cookies cleared!

Last edited by sarettah; 11-27-2012 at 03:32 PM..
sarettah is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote