<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 5/10/2014 11:51 AM, jacek burghardt
wrote:<br>
</div>
<blockquote
cite="mid:CAHyyzzQ_X6LY3=kz5TjGX0Q7AJen7HxFu9c_itwGngTtg2d+rQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>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</div>
<div>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 </div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://www.mythtv.org/mailman/listinfo/mythtv-users">http://www.mythtv.org/mailman/listinfo/mythtv-users</a>
<a class="moz-txt-link-freetext" href="http://wiki.mythtv.org/Mailing_List_etiquette">http://wiki.mythtv.org/Mailing_List_etiquette</a>
MythTV Forums: <a class="moz-txt-link-freetext" href="https://forum.mythtv.org">https://forum.mythtv.org</a>
</pre>
</blockquote>
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.<br>
<br>
This should do what you want. I'd use phpmyadmin to create a backup
and test it there first:<br>
<br>
update channel set channum = replace(channum, '-', '1') where
instr(channum, '-') > 0;<br>
</body>
</html>