I feel a little stupid about this one, but to be fair, you can't know everything. In MySQL you can 'update' part of a field (like search and replace) with the 'replace' function:

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

I've always just written a little program to select all records and then loop through and do the replace in PHP. This is obviously much easier. Google is my friend.
- jim 12-21-2008 8:02 pm


return to: jimslog


"...im/weblog/archive/complete/?/ Content-Length: 0 Connection: close Content-Type: text/html; charset=ISO-8859-1 ..."

from page: http://www.digitalmediatree.com/jim/weblog/archive/complete/

also from:
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete/
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete
http://www.digitalmediatree.com/jim/weblog/archive/complete

first followed here: 12-23-2008 7:56 pm
number of times: 1