-- mssql
update channel
set
xmltvid = b.xmltvid
from channel a, channel b
where
a.name like b.channum and
left(a.channum,1) between 0 and 9


--mysql
update channel a, channel b 
set
a.xmltvid = b.xmltvid
where
a.name like b.channum and
left(a.channum,1) between 0 and 9