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

Next revision		Previous revision
sql:update_text_fields [2023/02/15 17:20] – created ashleysql:update_text_fields [2023/02/15 17:20] (current) – ashley
Line 1: Line 1:
 To remove text in SQL fields To remove text in SQL fields
  
-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.1676481613.txt.gz · Last modified: (external edit)