The Slades Wiki

Site Tools

Trace: • update_text_fields
sql:update_text_fields

This is an old revision of the document!

To remove text in SQL fields

UPDATE [EZTV].[dbo].[Channels] SET IP = REPLACE(CAST(IP AS varchar(MAX)) 

                                             ,'&latency=300', '')
FROM [EZTV].[dbo].[Channels]
where IP LIKE '%latency%'
and DisplayName like '%lhr87 shld%'
	and DisplayName like '%SRT%'
sql/update_text_fields.1676481621.txt.gz · Last modified: (external edit)