I apologize for having to resort to sending what is most likely a simple
tech support question regarding PostgreSQL to this list but I have not
been able to find the answer in the documentation.
I am responsible for managing a database containing over 6,000 records of
US Forest Service Research publications
(http://www.srs.fs.usda.gov/pubs/search.jsp) and I need to do a simple
search and replace in one of the columns. In these records we have a
field for URLs of the location the research publications and I need to
change the base URL from www.srs.fs.fed.us to www.srs.fs.usda.gov. It
seems like this "search and replace" would be a simple thing to do with an
UPDATE command but I am having great difficulty making this work.
The table definition I am trying to update is: url. At first I thought
about using a simple UPDATE command like this:
UPDATE publications SET url = 'www.srs.fs.usda.gov' WHERE url =
'www.srs.fs.fed.us';
Of course that would work fine but "www.srs.fs.fed.us" is only part of a
complete URL such as: http://www.srs.fs.fed.us/pubs/rp/rp_se263.pdf. My
problem (among other things!) is that I don't know how to pass along
wildcards so that I do not change the other parts of the complete URL. I
have tried substituting "like" for "=" and trying to use the wildcard of
"%" but to no avail. I am really just guessing here.
Any help would be greatly appreciated!
Best,
--rdm
=======================================
Randy D. McCracken (0>
Web Guy //\
Communications Group V_/_
USDA/FS - Southern Research Station
E-Mail: rdm@srs.fs.usda.gov
Voice: (828) 259-0518
Fax: (828) 257-4840
Web: http://www.srs.fs.fed.us/
=======================================
