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

Tim Draper veehexx at gmail.com
Sat Jul 9 20:35:55 UTC 2011


got it;
delete from channel where name='BBC ONE' AND sourceid=5;

... so close the first time :)




On 9 July 2011 21:25, Tim Draper <veehexx at gmail.com> wrote:

> 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/b7bfc539/attachment.html 


More information about the mythtv-users mailing list