On Sun, 11 May 2014 12:40:01 -0600, you wrote: >I found this update channel set channum = channum + 10000 where sourceid in >('4','5','6'); >now how i get list of sourceids corresponding to source name >I am using workbench to explore table but is not very clear select sourceid,name from videosource order by sourceid;