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.