Changing EVERY iteration of a word in a table is simple with the REPLACE function. example
SET col1 = (REPLACE (col1, 'widget', 'bigwidget'))
But how would I write that to replace only the FIRST iteration of the word in the table? Or how would I make sure the word is not inside markup such as a link?
edit: in case it helps I want to replace keywords with links to their respective pages but only the first instance on any given page/table. I don't want to link the same keyword 20 times on a page.