UPDATE channel SET channum = '1' WHERE name = 'BBC ONE';
UPDATE channel SET channum = '2' WHERE name = 'BBC TWO';
UPDATE channel SET channum = '3' WHERE name = 'ITV1';
UPDATE channel SET channum = '4' WHERE name = 'Channel 4';
UPDATE channel SET channum = '5' WHERE name = 'five';
UPDATE channel SET channum = '6' WHERE name = 'ITV2';
UPDATE channel SET channum = '7' WHERE name = 'BBC THREE';
UPDATE channel SET channum = '9' WHERE name = 'BBC FOUR';
UPDATE channel SET channum = '10' WHERE name = 'ITV3';
UPDATE channel SET channum = '11' WHERE name = 'Sky Travel';
UPDATE channel SET channum = '12' WHERE name = 'UKTV History';
UPDATE channel SET channum = '13' WHERE name = 'More 4';
UPDATE channel SET channum = '14' WHERE name = 'E4';
UPDATE channel SET channum = '15' WHERE name = 'abc1';
UPDATE channel SET channum = '16' WHERE name = 'QVC';
UPDATE channel SET channum = '18' WHERE name = 'The HITS';
UPDATE channel SET channum = '19' WHERE name = 'UKTV Br\'tIdeas';
UPDATE channel SET channum = '20' WHERE name = 'f tn';
UPDATE channel SET channum = '21' WHERE name = 'TMF';
UPDATE channel SET channum = '22' WHERE name = 'Ideal World';
UPDATE channel SET channum = '23' WHERE name = 'bid tv';
UPDATE channel SET channum = '24' WHERE name = 'price-drop tv';
UPDATE channel SET channum = '30' WHERE name = 'ITV4';
UPDATE channel SET channum = '31' WHERE name = 'More 4+1';
UPDATE channel SET channum = '32' WHERE name = 'E4+1';
UPDATE channel SET channum = '34' WHERE name = 'SETANTA SPORTS';
UPDATE channel SET channum = '35' WHERE name = 'Men & Motors';
UPDATE channel SET channum = '36' WHERE name = 'Xtraview';
UPDATE channel SET channum = '37' WHERE name = 'Quiz Call';
UPDATE channel SET channum = '70' WHERE name = 'CBBC Channel';
UPDATE channel SET channum = '71' WHERE name = 'CBeebies';
UPDATE channel SET channum = '75' WHERE name = 'CITV';
UPDATE channel SET channum = '80' WHERE name = 'BBC NEWS 24';
UPDATE channel SET channum = '81' WHERE name = 'ITV News';
UPDATE channel SET channum = '82' WHERE name = 'Sky News';
UPDATE channel SET channum = '83' WHERE name = 'Sky Spts News';
UPDATE channel SET channum = '85' WHERE name = 'BBC PARLMNT';
UPDATE channel SET channum = '87' WHERE name = 'Community';
UPDATE channel SET channum = '88' WHERE name = 'Teachers\' TV';
UPDATE channel SET channum = '98' WHERE name = 'Red Hot';
UPDATE channel SET channum = '105' WHERE name = 'BBCi';
UPDATE channel SET channum = '301' WHERE name = '301';
UPDATE channel SET channum = '302' WHERE name = '302';
UPDATE channel SET channum = '303' WHERE name = '303';
SELECT * FROM channel ORDER BY CONVERT(channum,UNSIGNED);