Sky frequency numbers

From MythTV Official Wiki
Jump to: navigation, search

Sky recently (28th Feb 2006) decided to move round their channel numbers. This script is based on the channel numbers given on this digital spy page. It uses the names provided by default from the tv_grab_uk_rt script and should work as is for the majority of users.

update channel set freqid='185' where upper(name) = upper('abc1');
update channel set freqid='143' where upper(name) = upper('BBC 1 (ROI)');
update channel set freqid='988' where upper(name) = upper('BBC 1 Cl');
update channel set freqid='980' where upper(name) = upper('BBC 1 E Mids');
update channel set freqid='981' where upper(name) = upper('BBC 1 East (E)');
update channel set freqid='982' where upper(name) = upper('BBC 1 East (W)');
update channel set freqid='974' where upper(name) = upper('BBC 1 London');
update channel set freqid='978' where upper(name) = upper('BBC 1 N West');
update channel set freqid='975' where upper(name) = upper('BBC 1 NE & C');
update channel set freqid='973' where upper(name) = upper('BBC 1 NI');
update channel set freqid='985' where upper(name) = upper('BBC 1 Oxford');
update channel set freqid='983' where upper(name) = upper('BBC 1 S East');
update channel set freqid='987' where upper(name) = upper('BBC 1 S West');
update channel set freqid='971' where upper(name) = upper('BBC 1 Scotland');
update channel set freqid='984' where upper(name) = upper('BBC 1 South');
update channel set freqid='979' where upper(name) = upper('BBC 1 West Midlands');
update channel set freqid='972' where upper(name) = upper('BBC 1 Wales');
update channel set freqid='986' where upper(name) = upper('BBC 1 West');
update channel set freqid='976' where upper(name) = upper('BBC 1 Yorks');
update channel set freqid='977' where upper(name) = upper('BBC 1 Yrks&Lin');
update channel set freqid='144' where upper(name) = upper('BBC 2 (ROI)');
update channel set freqid='989' where upper(name) = upper('BBC 2 England');
update channel set freqid='992' where upper(name) = upper('BBC 2 Northern Ireland');
update channel set freqid='990' where upper(name) = upper('BBC 2 Scotland');
update channel set freqid='991' where upper(name) = upper('BBC 2 West');
update channel set freqid='116' where upper(name) = upper('BBC FOUR');
update channel set freqid='115' where upper(name) = upper('BBC THREE');
update channel set freqid='101' where upper(name) = upper('BBC1');
update channel set freqid='102' where upper(name) = upper('BBC2');
update channel set freqid='115' where upper(name) = upper('BBC3');
update channel set freqid='116' where upper(name) = upper('BBC4');
update channel set freqid='148' where upper(name) = upper('BEN');
update channel set freqid='161' where upper(name) = upper('Biography Channel');
update channel set freqid='165' where upper(name) = upper('Bonanza');
update channel set freqid='124' where upper(name) = upper('Bravo');
update channel set freqid='125' where upper(name) = upper('Bravo +1');
update channel set freqid='121' where upper(name) = upper('Challenge');
update channel set freqid='122' where upper(name) = upper('Challenge +1');
update channel set freqid='104' where upper(name) = upper('Channel 4');
update channel set freqid='994' where upper(name) = upper('Channel 4 (AD)');
update channel set freqid='104' where upper(name) = upper('Channel 4/TG4/S4C');
update channel set freqid='996' where upper(name) = upper('Chl Line-up*');
update channel set freqid='155' where upper(name) = upper('E! Entertainment');
update channel set freqid='140' where upper(name) = upper('E4');
update channel set freqid='141' where upper(name) = upper('E4 +1');
update channel set freqid='105' where upper(name) = upper('five');
update channel set freqid='157' where upper(name) = upper('Ftn');
update channel set freqid='179' where upper(name) = upper('FX');
update channel set freqid='180' where upper(name) = upper('FX+');
update channel set freqid='153' where upper(name) = upper('Hallmark');
update channel set freqid='163' where upper(name) = upper('Hollywood TV');
update channel set freqid='181' where upper(name) = upper('Information TV');
update channel set freqid='993' where upper(name) = upper('ITV1 (AD)');
update channel set freqid='103' where upper(name) = upper('ITV1 / TV3');
update channel set freqid='118' where upper(name) = upper('ITV2');
update channel set freqid='119' where upper(name) = upper('ITV3');
update channel set freqid='120' where upper(name) = upper('ITV4');
update channel set freqid='137' where upper(name) = upper('Life TV');
update channel set freqid='138' where upper(name) = upper('Life2');
update channel set freqid='139' where upper(name) = upper('LifeShowcase');
update channel set freqid='112' where upper(name) = upper('LIVING tv');
update channel set freqid='113' where upper(name) = upper('LIVING tv +1');
update channel set freqid='114' where upper(name) = upper('LIVING tv 2');
update channel set freqid='131' where upper(name) = upper('Men & Motors');
update channel set freqid='142' where upper(name) = upper('More4');
update channel set freqid='189' where upper(name) = upper('More4 +1');
update channel set freqid='159' where upper(name) = upper('OBE');
update channel set freqid='173' where upper(name) = upper('Open Access 2');
update channel set freqid='127' where upper(name) = upper('Paramount Comedy +1');
update channel set freqid='126' where upper(name) = upper('Paramount Comedy');
update channel set freqid='128' where upper(name) = upper('Paramount Comedy 2');
update channel set freqid='183' where upper(name) = upper('Passion TV');
update channel set freqid='195' where upper(name) = upper('Propeller');
update channel set freqid='187' where upper(name) = upper('Raj TV');
update channel set freqid='193' where upper(name) = upper('Rapture TV');
update channel set freqid='150' where upper(name) = upper('Reality TV');
update channel set freqid='151' where upper(name) = upper('Reality TV +1');
update channel set freqid='175' where upper(name) = upper('RTE1');
update channel set freqid='176' where upper(name) = upper('RTE2');
update channel set freqid='135' where upper(name) = upper('S4C Digital');
update channel set freqid='129' where upper(name) = upper('Sci-Fi');
update channel set freqid='999' where upper(name) = upper('Sky Cust Ch*');
update channel set freqid='106' where upper(name) = upper('Sky One');
update channel set freqid='108' where upper(name) = upper('Sky Three');
update channel set freqid='107' where upper(name) = upper('Sky Two');
update channel set freqid='998' where upper(name) = upper('Sky Welcome*');
update channel set freqid='177' where upper(name) = upper('TG4');
update channel set freqid='133' where upper(name) = upper('UKTV Drama');
update channel set freqid='109' where upper(name) = upper('UKTV Gold');
update channel set freqid='110' where upper(name) = upper('UKTV Gold +1');
update channel set freqid='111' where upper(name) = upper('UKTV G2');
update channel set freqid='169' where upper(name) = upper('UKTV G2 +1');
update channel set freqid='146' where upper(name) = upper('You TV');
update channel set freqid='250' where upper(name) = upper('Discovery Real Time');
update channel set freqid='251' where upper(name) = upper('Discovery Real Time +1');
update channel set freqid='252' where upper(name) = upper('Discovery Real Time Extra');
update channel set freqid='253' where upper(name) = upper('Sky Travel');
update channel set freqid='254' where upper(name) = upper('Sky Travel +1');
update channel set freqid='255' where upper(name) = upper('Sky Travel Extra');
update channel set freqid='256' where upper(name) = upper('UKTV Style');
update channel set freqid='257' where upper(name) = upper('UKTV Style +1');
update channel set freqid='258' where upper(name) = upper('UKTV Style Gardens');
update channel set freqid='259' where upper(name) = upper('UKTV Food');
update channel set freqid='260' where upper(name) = upper('UKTV Food +1');
update channel set freqid='261' where upper(name) = upper('Travel Channel');
update channel set freqid='262' where upper(name) = upper('Travel Channel +1');
update channel set freqid='264' where upper(name) = upper('Discovery Home & Health');
update channel set freqid='265' where upper(name) = upper('Discovery Home & Health +1');
update channel set freqid='267' where upper(name) = upper('Artsworld');
update channel set freqid='269' where upper(name) = upper('UKTV Bright Ideas');
update channel set freqid='271' where upper(name) = upper('Performance');
update channel set freqid='273' where upper(name) = upper('Fashion TV');
update channel set freqid='275' where upper(name) = upper('Majestic TV');
update channel set freqid='277' where upper(name) = upper('LONDON TV');
update channel set freqid='279' where upper(name) = upper('Real Estate TV');
update channel set freqid='281' where upper(name) = upper('Wine TV');
update channel set freqid='283' where upper(name) = upper('Discovery Travel & Living');
update channel set freqid='285' where upper(name) = upper('Baby Channel');
update channel set freqid='301' where upper(name) = upper('Sky Movies 1');
update channel set freqid='302' where upper(name) = upper('Sky Movies 2');
update channel set freqid='303' where upper(name) = upper('Sky Movies 3');
update channel set freqid='304' where upper(name) = upper('Sky Movies 4');
update channel set freqid='305' where upper(name) = upper('Sky Movies 5');
update channel set freqid='306' where upper(name) = upper('Sky Movies 6');
update channel set freqid='307' where upper(name) = upper('Sky Movies 7');
update channel set freqid='308' where upper(name) = upper('Sky Movies 8');
update channel set freqid='309' where upper(name) = upper('Sky Movies 9');
update channel set freqid='310' where upper(name) = upper('Sky Movies 10');
update channel set freqid='313' where upper(name) = upper('Sky Cinema 1');
update channel set freqid='314' where upper(name) = upper('Sky Cinema 2');
update channel set freqid='315' where upper(name) = upper('FilmFour');
update channel set freqid='316' where upper(name) = upper('FilmFour +1');
update channel set freqid='317' where upper(name) = upper('FilmFour Weekly');
update channel set freqid='319' where upper(name) = upper('TCM');
update channel set freqid='321' where upper(name) = upper('The Horror Channel');
update channel set freqid='323' where upper(name) = upper('True Movies');
update channel set freqid='325' where upper(name) = upper('matineemovies');
update channel set freqid='327' where upper(name) = upper('bad movies');
update channel set freqid='340' where upper(name) = upper('MTV');
update channel set freqid='341' where upper(name) = upper('VH1');
update channel set freqid='342' where upper(name) = upper('MTV Hits');
update channel set freqid='343' where upper(name) = upper('MTV Base');
update channel set freqid='344' where upper(name) = upper('MTV Dance');
update channel set freqid='345' where upper(name) = upper('MTV2');
update channel set freqid='346' where upper(name) = upper('VH2');
update channel set freqid='347' where upper(name) = upper('VH1 Classic');
update channel set freqid='348' where upper(name) = upper('TMF: The Music Factory');
update channel set freqid='349' where upper(name) = upper('The Box');
update channel set freqid='350' where upper(name) = upper('KISS');
update channel set freqid='351' where upper(name) = upper('Smash Hits');
update channel set freqid='352' where upper(name) = upper('Magic');
update channel set freqid='353' where upper(name) = upper('Q');
update channel set freqid='354' where upper(name) = upper('Kerrang!');
update channel set freqid='355' where upper(name) = upper('Chart Show TV');
update channel set freqid='356' where upper(name) = upper('The Vault');
update channel set freqid='357' where upper(name) = upper('B4');
update channel set freqid='358' where upper(name) = upper('The Hits');
update channel set freqid='359' where upper(name) = upper('Classic FM TV');
update channel set freqid='360' where upper(name) = upper('Channel U');
update channel set freqid='361' where upper(name) = upper('Fizz');
update channel set freqid='362' where upper(name) = upper('The Amp');
update channel set freqid='364' where upper(name) = upper('Scuzz');
update channel set freqid='366' where upper(name) = upper('Flaunt');
update channel set freqid='368' where upper(name) = upper('Musicians Ch.');
update channel set freqid='395' where upper(name) = upper('Music Choice');
update channel set freqid='396' where upper(name) = upper('Music Choice');
update channel set freqid='Spo' where upper(name) = upper('rts');
update channel set freqid='401' where upper(name) = upper('Sky Sports 1');
update channel set freqid='402' where upper(name) = upper('Sky Sports 2');
update channel set freqid='403' where upper(name) = upper('Sky Sports 3');
update channel set freqid='404' where upper(name) = upper('Sky Sports Xtra');
update channel set freqid='406' where upper(name) = upper('MUTV');
update channel set freqid='408' where upper(name) = upper('Sky Spts News');
update channel set freqid='410' where upper(name) = upper('British Eurosport');
update channel set freqid='410' where upper(name) = upper('Eurosport');
update channel set freqid='411' where upper(name) = upper('British Eurosport 2');
update channel set freqid='413' where upper(name) = upper('Motors TV');
update channel set freqid='415' where upper(name) = upper('At The Races');
update channel set freqid='417' where upper(name) = upper('NASN');
update channel set freqid='419' where upper(name) = upper('Extreme Sports');
update channel set freqid='421' where upper(name) = upper('Chelsea TV');
update channel set freqid='423' where upper(name) = upper('Golf Channel');
update channel set freqid='425' where upper(name) = upper('Channel 425');
update channel set freqid='427' where upper(name) = upper('TWC');
update channel set freqid='429' where upper(name) = upper('Setanta Sports 1');
update channel set freqid='430' where upper(name) = upper('Setanta Sports 2');
update channel set freqid='432' where upper(name) = upper('Racing UK');
update channel set freqid='434' where upper(name) = upper('Setanta Ireland');
update channel set freqid='436' where upper(name) = upper('Celtic TV');
update channel set freqid='438' where upper(name) = upper('Rangers TV');
update channel set freqid='440' where upper(name) = upper('Sport Nation');
update channel set freqid='480' where upper(name) = upper('PremPlus');
update channel set freqid='481' where upper(name) = upper('Setanta PPV1');
update channel set freqid='482' where upper(name) = upper('Setanta PPV2');
update channel set freqid='501' where upper(name) = upper('Sky News');
update channel set freqid='502' where upper(name) = upper('Bloomberg');
update channel set freqid='503' where upper(name) = upper('BBC NEWS 24');
update channel set freqid='504' where upper(name) = upper('BBC Parliament');
update channel set freqid='505' where upper(name) = upper('CNBC');
update channel set freqid='506' where upper(name) = upper('CNN');
update channel set freqid='507' where upper(name) = upper('S4C~2');
update channel set freqid='509' where upper(name) = upper('EuroNews');
update channel set freqid='510' where upper(name) = upper('FOX News');
update channel set freqid='511' where upper(name) = upper('CCTV-9');
update channel set freqid='512' where upper(name) = upper('SAW');
update channel set freqid='513' where upper(name) = upper('NDTV 24x7');
update channel set freqid='520' where upper(name) = upper('Discovery Channel');
update channel set freqid='521' where upper(name) = upper('Discovery Channel +1');
update channel set freqid='522' where upper(name) = upper('Discovery Civilisation');
update channel set freqid='523' where upper(name) = upper('Discovery Science');
update channel set freqid='524' where upper(name) = upper('Discovery Wings');
update channel set freqid='526' where upper(name) = upper('National Geographic');
update channel set freqid='527' where upper(name) = upper('National Geographic +1');
update channel set freqid='528' where upper(name) = upper('Adventure One');
update channel set freqid='529' where upper(name) = upper('The History Channel');
update channel set freqid='530' where upper(name) = upper('The History Channel +1');
update channel set freqid='532' where upper(name) = upper('UKTV Documentary');
update channel set freqid='533' where upper(name) = upper('UKTV Documentary +1');
update channel set freqid='534' where upper(name) = upper('UKTV People');
update channel set freqid='535' where upper(name) = upper('Animal Planet');
update channel set freqid='536' where upper(name) = upper('Animal Planet +1');
update channel set freqid='537' where upper(name) = upper('UKTV History');
update channel set freqid='538' where upper(name) = upper('UKTV History +1');
update channel set freqid='539' where upper(name) = upper('Community Channel');
update channel set freqid='541' where upper(name) = upper('UKTV People +1');
update channel set freqid='601' where upper(name) = upper('Cartoon Network');
update channel set freqid='602' where upper(name) = upper('Cartoon Network +1');
update channel set freqid='603' where upper(name) = upper('Boomerang');
update channel set freqid='604' where upper(name) = upper('Nickelodeon');
update channel set freqid='605' where upper(name) = upper('Nick Replay');
update channel set freqid='606' where upper(name) = upper('Nicktoons TV');
update channel set freqid='607' where upper(name) = upper('Trouble');
update channel set freqid='608' where upper(name) = upper('Trouble Reload');
update channel set freqid='609' where upper(name) = upper('Jetix');
update channel set freqid='610' where upper(name) = upper('Jetix +1');
update channel set freqid='611' where upper(name) = upper('Disney Channel');
update channel set freqid='612' where upper(name) = upper('Disney Channel +1');
update channel set freqid='613' where upper(name) = upper('Toon Disney');
update channel set freqid='614' where upper(name) = upper('Playhouse Disney');
update channel set freqid='615' where upper(name) = upper('Discovery Kids');
update channel set freqid='616' where upper(name) = upper('CBBC');
update channel set freqid='616' where upper(name) = upper('CBBC Channel');
update channel set freqid='617' where upper(name) = upper('CBeebies');
update channel set freqid='618' where upper(name) = upper('Nick Jr.');
update channel set freqid='619' where upper(name) = upper('POP');
update channel set freqid='620' where upper(name) = upper('Tiny Pop');
update channel set freqid='621' where upper(name) = upper('Toonami');
update channel set freqid='630' where upper(name) = upper('QVC');
update channel set freqid='631' where upper(name) = upper('iBuy TV');
update channel set freqid='632' where upper(name) = upper('iBuy TV2');
update channel set freqid='633' where upper(name) = upper('TV SHOP');
update channel set freqid='634' where upper(name) = upper('Ideal World');
update channel set freqid='635' where upper(name) = upper('price-drop tv');
update channel set freqid='636' where upper(name) = upper('Pitch TV');
update channel set freqid='637' where upper(name) = upper('Thomson TV');
update channel set freqid='638' where upper(name) = upper('Simply Shop.');
update channel set freqid='639' where upper(name) = upper('Best Direct');
update channel set freqid='640' where upper(name) = upper('Superstore TV');
update channel set freqid='641' where upper(name) = upper('Simply Ideas');
update channel set freqid='642' where upper(name) = upper('Shop Vector');
update channel set freqid='643' where upper(name) = upper('TV Warehouse');
update channel set freqid='644' where upper(name) = upper('bid tv');
update channel set freqid='645' where upper(name) = upper('Thomas Cook TV');
update channel set freqid='646' where upper(name) = upper('Gems.tv');
update channel set freqid='647' where upper(name) = upper('Pitch TV Plus');
update channel set freqid='648' where upper(name) = upper('Best Direct+');
update channel set freqid='649' where upper(name) = upper('Shop on TV');
update channel set freqid='650' where upper(name) = upper('Thane Direct');
update channel set freqid='651' where upper(name) = upper('TVW Select');
update channel set freqid='652' where upper(name) = upper('Vector 24/7');
update channel set freqid='653' where upper(name) = upper('Stop & Shop');
update channel set freqid='654' where upper(name) = upper('YES');
update channel set freqid='655' where upper(name) = upper('speedauctiontv');
update channel set freqid='656' where upper(name) = upper('Myphone.tv');
update channel set freqid='657' where upper(name) = upper('eeZee tv');
update channel set freqid='658' where upper(name) = upper('Vitality');
update channel set freqid='659' where upper(name) = upper('SkyTravelShop');
update channel set freqid='660' where upper(name) = upper('Gems.tv 2');
update channel set freqid='661' where upper(name) = upper('Create & Craft');
update channel set freqid='662' where upper(name) = upper('Teletext Hols');
update channel set freqid='663' where upper(name) = upper('Broadband UK');
update channel set freqid='664' where upper(name) = upper('Golf Pro-Shop');
update channel set freqid='665' where upper(name) = upper('We Deliver TV');
update channel set freqid='666' where upper(name) = upper('Max TV');
update channel set freqid='667' where upper(name) = upper('OneTV');
update channel set freqid='670' where upper(name) = upper('Choices UK TV');
update channel set freqid='671' where upper(name) = upper('Star Bazaar TV');
update channel set freqid='672' where upper(name) = upper('GDTV');
update channel set freqid='673' where upper(name) = upper('2ShopTV');
update channel set freqid='674' where upper(name) = upper('treasures.tv');
update channel set freqid='760' where upper(name) = upper('GOD Channel');
update channel set freqid='761' where upper(name) = upper('GOD 2');
update channel set freqid='762' where upper(name) = upper('Wonderful');
update channel set freqid='763' where upper(name) = upper('TBN Europe');
update channel set freqid='764' where upper(name) = upper('DAYSTAR');
update channel set freqid='765' where upper(name) = upper('revelation');
update channel set freqid='766' where upper(name) = upper('UCB TV');
update channel set freqid='767' where upper(name) = upper('INI');
update channel set freqid='768' where upper(name) = upper('LOVEWORLD TV');
update channel set freqid='769' where upper(name) = upper('EWTN');
update channel set freqid='770' where upper(name) = upper('Gospel Channel');
update channel set freqid='771' where upper(name) = upper('DoveVision TV');
update channel set freqid='780' where upper(name) = upper('B4U Movies');
update channel set freqid='781' where upper(name) = upper('B4U Music');
update channel set freqid='782' where upper(name) = upper('Sony TV Asia');
update channel set freqid='783' where upper(name) = upper('STAR News');
update channel set freqid='784' where upper(name) = upper('STAR Plus');
update channel set freqid='785' where upper(name) = upper('PCNE Chinese');
update channel set freqid='786' where upper(name) = upper('VECTONE Urdu');
update channel set freqid='787' where upper(name) = upper('mta-muslim tv');
update channel set freqid='788' where upper(name) = upper('Zee TV');
update channel set freqid='789' where upper(name) = upper('Zee Music');
update channel set freqid='790' where upper(name) = upper('Zee Cinema');
update channel set freqid='791' where upper(name) = upper('Bangla TV');
update channel set freqid='792' where upper(name) = upper('ARY Digital');
update channel set freqid='793' where upper(name) = upper('MATV National');
update channel set freqid='794' where upper(name) = upper('VectoneBusines');
update channel set freqid='795' where upper(name) = upper('PTV Prime');
update channel set freqid='796' where upper(name) = upper('VECTONE Tamil');
update channel set freqid='797' where upper(name) = upper('SouthForYou');
update channel set freqid='798' where upper(name) = upper('AlphaEtcPun');
update channel set freqid='799' where upper(name) = upper('Al Jazeera');
update channel set freqid='800' where upper(name) = upper('Vectone Bangla');
update channel set freqid='801' where upper(name) = upper('DW-TV');
update channel set freqid='802' where upper(name) = upper('TVEi');
update channel set freqid='803' where upper(name) = upper('Vectone Punjab');
update channel set freqid='804' where upper(name) = upper('Abu Dhabi TV');
update channel set freqid='805' where upper(name) = upper('TV5');
update channel set freqid='806' where upper(name) = upper('MAX');
update channel set freqid='807' where upper(name) = upper('ATN Global');
update channel set freqid='808' where upper(name) = upper('Aastha TV');
update channel set freqid='809' where upper(name) = upper('Apna Bazaar');
update channel set freqid='810' where upper(name) = upper('Record TV');
update channel set freqid='811' where upper(name) = upper('Vectone Sinhla');
update channel set freqid='812' where upper(name) = upper('Barablu');
update channel set freqid='813' where upper(name) = upper('Islam Channel');
update channel set freqid='814' where upper(name) = upper('Channel \'S\'');
update channel set freqid='815' where upper(name) = upper('GEO UK');
update channel set freqid='816' where upper(name) = upper('Zee Gujarati');
update channel set freqid='817' where upper(name) = upper('DM Digital');
update channel set freqid='818' where upper(name) = upper('ATN Bangla');
update channel set freqid='840' where upper(name) = upper('iPlay');
update channel set freqid='841' where upper(name) = upper('AVAGO');
update channel set freqid='842' where upper(name) = upper('Quiz Nation');
update channel set freqid='843' where upper(name) = upper('PokerZone');
update channel set freqid='844' where upper(name) = upper('Poker Channel');
update channel set freqid='845' where upper(name) = upper('Sky Vegas Live');
update channel set freqid='847' where upper(name) = upper('Vegas 24/7');
update channel set freqid='848' where upper(name) = upper('Jackpot TV');
update channel set freqid='849' where upper(name) = upper('Big Game TV!');
update channel set freqid='850' where upper(name) = upper('YouPlay TV');
update channel set freqid='851' where upper(name) = upper('Your TV');
update channel set freqid='852' where upper(name) = upper('Quiz TV');
update channel set freqid='853' where upper(name) = upper('Quiz Call');
update channel set freqid='870' where upper(name) = upper('The Dating Channel');
update channel set freqid='871' where upper(name) = upper('Gay Date TV');
update channel set freqid='872' where upper(name) = upper('Look4Love TV');
update channel set freqid='873' where upper(name) = upper('Gay Network');
update channel set freqid='874' where upper(name) = upper('Chat Box');
update channel set freqid='880' where upper(name) = upper('Teachers\' tv (satellite/cable/DSL)');
update channel set freqid='881' where upper(name) = upper('Pub Channel');
update channel set freqid='882' where upper(name) = upper('Sky Venue');
update channel set freqid='883' where upper(name) = upper('Open Access');
update channel set freqid='884' where upper(name) = upper('Audi Channel');
update channel set freqid='899' where upper(name) = upper('Sky Cust Ch*');
update channel set freqid='900' where upper(name) = upper('Playboy TV');
update channel set freqid='901' where upper(name) = upper('The Adult Channel');
update channel set freqid='902' where upper(name) = upper('Spice Extreme');
update channel set freqid='903' where upper(name) = upper('Television X');
update channel set freqid='904' where upper(name) = upper('Television X2');
update channel set freqid='905' where upper(name) = upper('Television X3');
update channel set freqid='906' where upper(name) = upper('Game Network');
update channel set freqid='908' where upper(name) = upper('FriendlyTV');
update channel set freqid='909' where upper(name) = upper('L!VE TV');
update channel set freqid='910' where upper(name) = upper('Get Lucky TV');
update channel set freqid='911' where upper(name) = upper('Lucky Star');
update channel set freqid='912' where upper(name) = upper('Playboy One');
update channel set freqid='913' where upper(name) = upper('You TV2');
update channel set freqid='914' where upper(name) = upper('You TV2 Extra');
update channel set freqid='915' where upper(name) = upper('Turn On TV');
update channel set freqid='920' where upper(name) = upper('Climax3 - 1');
update channel set freqid='921' where upper(name) = upper('Climax3 - 2');
update channel set freqid='922' where upper(name) = upper('Climax3 - 3');
update channel set freqid='923' where upper(name) = upper('SportxxxBabes');
update channel set freqid='924' where upper(name) = upper('Red Hot R');
update channel set freqid='925' where upper(name) = upper('RH 40+ Wives');
update channel set freqid='926' where upper(name) = upper('red hot amateur');
update channel set freqid='927' where upper(name) = upper('RedHot All Girl');
update channel set freqid='928' where upper(name) = upper('Red Hot Wives');
update channel set freqid='929' where upper(name) = upper('Red Hot Climax');
update channel set freqid='930' where upper(name) = upper('Red Hot only 18');
update channel set freqid='931' where upper(name) = upper('Red Hot Movies');
update channel set freqid='932' where upper(name) = upper('XPLICITXXX');
update channel set freqid='933' where upper(name) = upper('Playboy TV');
update channel set freqid='934' where upper(name) = upper('Adult Channel');
update channel set freqid='935' where upper(name) = upper('Spice Extreme');
update channel set freqid='936' where upper(name) = upper('Hustler TV UK');
update channel set freqid='937' where upper(name) = upper('100% Babes');
update channel set freqid='938' where upper(name) = upper('XXX TV');
update channel set freqid='939' where upper(name) = upper('Amateur Babes');
update channel set freqid='940' where upper(name) = upper('Gay TV');
update channel set freqid='941' where upper(name) = upper('18PlusXXX');
update channel set freqid='942' where upper(name) = upper('XXXHousewive');
update channel set freqid='943' where upper(name) = upper('Live XXX TV');
update channel set freqid='944' where upper(name) = upper('18 Plus Movies');

You can use this to check for items which do not have a channel number (you may wish to blank the channel numbers before you run the original script).

SELECT name,freqid FROM channel WHERE freqid NOT RLIKE '^[0-9]{3}$';

If you use the standard channel numbers you may also want to update them to match.

update channel set channum=freqid where freqid RLIKE '^[0-9]{3}$';
update channel set channum='' where freqid NOT RLIKE '^[0-9]{3}$';