-- Use the following SQL to replace content in all 2sxc values
DECLARE @oldvalue NVARCHAR(MAX)
SET @oldvalue = 'Old value';
DECLARE @newvalue NVARCHAR(MAX)
SET @newvalue = 'New value'

-- Preview results
SELECT [Value] AS Original, REPLACE([Value], @oldvalue, @newvalue) as Replaced
FROM ToSIC_EAV_Values
WHERE [Value] LIKE N'%' + @oldvalue + '%' AND
ChangeLogDeleted IS NULL

-- Execute replace
--EXEC ToSIC_EAV_ChangeLogAdd @User = "Manual-Database-Replace"
--UPDATE ToSIC_EAV_Values
--SET [Value] = REPLACE([Value], @oldvalue, @newvalue)
--WHERE ([Value] LIKE N'%' + @oldvalue + '%') AND
--ChangeLogDeleted IS NULL
open_in_new open in new window
code Share
code
URL copied to clipboard.
Embed Checklist close
Copy Copy
Content Copyright

CC-BY 4.0

Translations

None

2sxc - Content Management for DNN & Oqtane Logo

2sxc - Content Management for DNN & Oqtane

QR-Code
azing.org/2sxc/r/x-4PqOdT
close

Durchsuche ganz Azing