Mass-replace a substring

UPDATE TABLE SET COLUMN = REPLACE(COLUMN, search_string, replace_string) WHERE COLUMN LIKE '%search_string%' --Example UPDATE DatabaseName.TableName SET PDF_NAME = REPLACE(PDF_NAME, '+', '_') WHERE PDF_NAME LIKE '%+%'

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.