Hi,
I have a database: "database1"
with a table: "news"
In news there is a field: "link" which contains urls.
I would like the query that will look at link to see if it contains
"http://www.myweb.com/track/track.php?" if it does do nothing.  If it
does not then I would like to append this to the beginning of the
existing URL.

I believe the query looks something like this:

UPDATE news 
SET link = 'http://www.MyWeb.com/track/track.php?' + link 
WHERE link not like '%www.myweb.com/track/track.php?%';

but it isn't producing the proper result.
Hope you can help.

Thanks,
Martin

Hi, 

You want to use the concat function for this. Example:

update news
set link = concat("http://www.myweb.com/track/track.php?", link)
where link not like '%www.myweb.com/track/track.php?%';

Thanks, 

webadept-ga

Thanks.  Perfect answer & fast.