UPDATE cameras SET screen = REPLACE(screen, 'img/video.mjpeg?COUNTER', 'img/snapshot.cgi?size=2') WHERE screen LIKE '%img/video.mjpeg?COUNTER%';
UPDATE cameras SET screen = REPLACE(screen, 'videostream.cgi?user=admin&pwd=', 'snapshot.cgi?user=admin&pwd=') WHERE screen LIKE '%videostream.cgi?user=admin&pwd=%';
UPDATE cameras SET screen = REPLACE(screen, '-wvhttp-01-/GetOneShot?image_size=640x480&frame_count=1000000000', '-wvhttp-01-/GetOneShot') WHERE screen LIKE '%-wvhttp-01-/GetOneShot?image_size=640x480&frame_count=1000000000%';
UPDATE cameras SET screen = REPLACE(screen, '?action=stream', '?action=snapshot') WHERE screen LIKE '%?action=stream%';
UPDATE cameras SET screen = REPLACE(screen, 'cam_1.cgi', 'cam_1.jpg') WHERE screen LIKE '%cam_1.cgi%';
UPDATE cameras SET screen = REPLACE(screen, 'cgi-bin/faststream.jpg?stream=half&fps=15&rand=COUNTER', 'cgi-bin/image.jpg') WHERE screen LIKE '%cgi-bin/faststream.jpg?stream=half&fps=15&rand=COUNTER%';
UPDATE cameras SET screen = REPLACE(screen, '/video', '/shot.jpg') WHERE screen LIKE '%/video';
UPDATE cameras SET screen = REPLACE(screen, '/mjpeg.cgi', '/image.jpg') WHERE screen LIKE '%/mjpeg.cgi';
UPDATE cameras SET screen = REPLACE(screen, 'axis-cgi/mjpg/video.cgi?camera=&resolution=640x480', 'jpg/image.jpg') WHERE screen LIKE '%axis-cgi/mjpg/video.cgi?camera=&resolution=640x480%';
UPDATE cameras SET screen = REPLACE(screen, 'GetData.cgi?CH=1', 'Jpeg/CamImg.jpg') WHERE screen LIKE '%GetData.cgi?CH=1%';