[mythtv-users] OT-ish: mySQL delete channel on certain source

[Tim Draper]

i've recently added an analogue/DVB tuner card, and due to a weak signal
some channels are not perfect and result in a pixelated image (my main tuner
is a dual sat-card).

until i get the terrestrial signal issue sorted, how do i exclude all
channels EXCEPT certain ones on a specific card?

i've tried the following command, but it fails as it's not valid:
delete channel where name='BBC ONE' AND sourceid=5;

thanks for any help! im sure it's very easy, but i have no real sql
experience
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20110709/2f2bde1b/attachment.html