Site Tools


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.1676481613.txt.gz · Last modified: (external edit)