update a string in a MySQL DB

UPDATE bib_publications SET pdf = replace(pdf, "oncoweb2", "oncoweb");