/*change streaminglym1int to streaming5*/
  /*UPDATE c SET c.url = REPLACE(c.url,'streaminglym1int.','streaming5.'),
  c.multicast_addr = REPLACE(c.multicast_addr,'streaminglym1int.','streaming5.')
  FROM [mdot-prod-nwconf].[dbo].[cctv_camera]c
  WHERE url LIKE '%051902%'*/

  /*change streaming5 to streaminglym1int*/
  /*
  UPDATE c SET c.url = REPLACE(c.url,'streaming5.','streaminglym1int.'),
  c.multicast_addr = REPLACE(c.multicast_addr,'streaming5.','streaminglym1int.')
  FROM [mdot-prod-nwconf].[dbo].[cctv_camera]c
  WHERE url LIKE '%051902%'
  */
  SELECT *, REPLACE(c.url,'streaming5.','streaminglym1int.'),
  REPLACE(c.multicast_addr,'streaming5.','streaminglym1int.')
  FROM cctv_camera c
  WHERE url LIKE '%051902%'