[mythtv-users] renumber channels

[jacek burghardt]

Thank you that worked


On Sat, May 10, 2014 at 2:38 PM, William Jacoby <bonelifer at gmail.com> wrote:

>  On 5/10/2014 11:51 AM, jacek burghardt wrote:
>
>  Can someone tell me how to renumber channels I created source fta and
> scanned channels now the channels have - infront of them so -1096 this
> makes impossible
> for then to entered in mythfrontend. How I can rename all channels and add
> 10000 in front so I want to rename -1096 to 11096 how I can do that in
> database
>
>
> _______________________________________________
> mythtv-users mailing listmythtv-users at mythtv.orghttp://www.mythtv.org/mailman/listinfo/mythtv-usershttp://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
>  On my channels in the US, my higher channels all have 1008_ attached to
> the front. So I've had to remove them with an SQL statement, which took
> awhile since I'm not good with creating them.
>
> This should do what you want. I'd use phpmyadmin to create a backup and
> test it there first:
>
> update channel set channum = replace(channum, '-', '1') where
> instr(channum, '-') > 0;
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20140510/fc1a755c/attachment.html>