(12-17-2012, 11:48 PM)Starscream Wrote: Can you be more specific?Well, i found some links in some post messages that points for example to: 'http://forums. shall not be named/Thread-dolphin-has-a-new-website', not this one, i didn't remember which ones, and that link should be 'http://forums.dolphin-emu.org/Thread-dolphin-has-a-new-website'.
So how about a select replacing where msg like '% shall not be named/%' to 'dolphin-emu.org/' since the domain has changed and those posts points to an error page.
Something like this:
Code:
UPDATE MyDB.MyTable SET MyDB.MyTable = REPLACE(MyDB.MyTable.MyField,' shall not be named/','dolphin-emu.org/') WHERE MyDB.MyTable.MyField like '% shall not be named/%';