update releases set categoryID = '2050' where releases.name regexp 'bluray|bd?25|bd?50|blu-ray|VC1|VC\-1|AVC' and releases.name not like '%264%' and releases.name not like '%wmv%' and releases.name not like '%xvid%' and categoryID = '2040';
update releases set categoryID = '2060' where name like '%3D%' and categoryID in (2040,2050);
update releases set categoryID = '2010' where releases.name like '% GER %' and categoryID in (2040,2050,2030,2060);
update releases set categoryID = '2010' where releases.searchname like '%.GER.%' and categoryID in (2040,2050,2030,2060);