replacing a whole lot of hyperlinks

M

Mark Kubicki

I have a table with a whole lot of records, all of which have the same
hyperlink entry (to a JPEG on our derver).
The hyperlink has changed (and needs to be replaced)...

What would be the most efficient method for replacing the data?

thanks in advance,
mark
 
L

Lord Kelvan

something like

update thetablewithhyperlink set fieldwithhyperlink = "newhyperlink"
where fieldwithhyperlink = "oldhyperlink"

Regards
Kelvan
 
Top