How do I search and replace only ONE part of a url in the URL field via the SQL Monitor?

http://www.google.com/?revid=28470&s=1

Just the number 28470 needs changing.

?

--------------------------------
Privacy Software

Try;

UPDATE lsql_Links SET URL = REPLACE(URL,'28470','thing to replace with');

NOTE: Please be careful with this command, and make a backup of your lsql_Links table ... just in case the output isn't quite what you were expecting

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Gracias!



--------------------------------
Privacy Software