Gossamer Forum: Products: Gossamer Links: Discussions: Re: [mapleleafweb] Search and Replace Example...: Edit Log

Gossamer Threads

Home : Products : Gossamer Links : Discussions :

Products: Gossamer Links: Discussions: Re: [mapleleafweb] Search and Replace Example...: Edit Log

Here is the list of edits for this post

Feb 12, 2007, 3:48 PM

brewt

Staff (4101 posts)

Feb 12, 2007, 3:48 PM

Re: [mapleleafweb] Search and Replace Example...

You might want to make it:

Code:
UPDATE Links SET URL = REPLACE(URL, 'http://www.example.ca/boardwiseii/Document.asp', 'http://sso.example.ca/e-Library/Document.asp') WHERE URL LIKE 'http://www.example.ca/boardwiseii/Document.asp%'

Just in case MySQL isn't smart about its updating (so it doesn't unnecessarily update the link timestamps.

Edit: it is smart about it, but it's slightly faster to do it like that anyways.

Adrian

Last edited by:

brewt: Feb 12, 2007, 3:49 PM

Edit Log:

Post edited by brewt Post edited by brewt (Staff) on Feb 12, 2007, 3:49 PM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676