update urole set unmatched_records= (select concat(regname,ID) from urole where rcount>1) where unmatched_data is null;

ID    DNAME      REGNAME       RCOUNT     Unmatched_Data
--------------------------------------------------------
1     Agency	  Agency	1          <Null>
2     Eastern	  Atlanta	1
3     Eastern	  Boston	1
4     Business 	  Business 	1
5     Canada	  Canada	2
6     Eastern	  Canada	2
7     Central	  Central	1
8     Central	  Central Region1
9     Central	  Chicago	1
10    Central	  Cincinnati	1
11    Marketing	  Marketing	1
12    Media	  Media	1
13    Media	 Media Eastern	1
14    Media	 Media Western	1
15    Custom Pub Custom Pub	2
16    Eastern	 Custom Pub	2     

update urole set unmatched_records= concat(regname,ID) where unmatched_data is null and rcount>1;