[mythtv-users] SQL command to delete range of channels

[ray cielencki]

delete from channel where chanid > '1099';
delete from program where chanid > '1099';

for me, it was more sporatic. i subscribe to 320-325 and 340-344, but not 330-334, 
etc...

/rayc

On 12 Sep 2003 at 9:57, Timothy.Weaver at at.redbull.com wrote:

> 
> 
> 
> 
> I can use the SQL command found in the documentation to remove channels
> individually from the database. Is there a command to remove a range of
> channels?
> 
> In my situation, I want to remove everything over channel 99. If someone
> can provide the general SQL command (if there is one) this would be great.
> I assume it is a combination of a SELECT and a DELETE.
> 
> Perhaps Robert could then include this in the online documentation in the
> section on how to remove channels.
> 
>