The Slades Wiki

Site Tools

Trace:
sql:update_text_fields

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
sql:update_text_fields [2023/02/15 17:20] – ashleysql:update_text_fields [2023/02/15 17:20] (current) – ashley
Line 2: Line 2:
  
  UPDATE [EZTV].[dbo].[Channels]  UPDATE [EZTV].[dbo].[Channels]
- SET IP = REPLACE(CAST(IP AS varchar(MAX)) + SET IP = REPLACE(CAST(IP AS varchar(MAX)),'&latency=300', '')
-                                               ,'&latency=300', '')+
   FROM [EZTV].[dbo].[Channels]   FROM [EZTV].[dbo].[Channels]
   where IP LIKE '%latency%'   where IP LIKE '%latency%'
  and DisplayName like '%lhr87 shld%'  and DisplayName like '%lhr87 shld%'
  and DisplayName like '%SRT%'  and DisplayName like '%SRT%'
sql/update_text_fields.1676481621.txt.gz · Last modified: (external edit)