[thelist] Interesting SQL Mass update
Jay Blanchard
jay.blanchard at niicommunications.com
Mon Oct 28 10:20:01 CST 2002
[snip]
I've got a small table, about 1000 rows or so, and some of the columns have
something like this in it:
<a href="../links/page1.html" target="_blank">
I want to remove the 'target="_blank"' part of the string. Is there a way to
do this mass update in SQL? I could probably do in ASP, but don't want to
have to resort to that - time.
[/snip]
UPDATE tblFoo
SET URL = '<a href="../links/page1.html">'
WHERE URL LIKE '%target="_bl%'
HTH!
Jay
More information about the thelist
mailing list