got it; <br><div style="margin-left: 40px;">delete from channel where name='BBC ONE' AND sourceid=5;<br><br></div>... so close the first time :)<br><br><br><br><br><div class="gmail_quote">On 9 July 2011 21:25, Tim Draper <span dir="ltr"><<a href="mailto:veehexx@gmail.com">veehexx@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">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).<br>
<br>until i get the terrestrial signal issue sorted, how do i exclude all channels EXCEPT certain ones on a specific card?<br>
<br>i've tried the following command, but it fails as it's not valid:<br><div style="margin-left:40px">delete channel where name='BBC ONE' AND sourceid=5;<br></div><br>thanks for any help! im sure it's very easy, but i have no real sql experience<br>
</blockquote></div><br>