Update MySQL table and ignore duplicate entries

Use UPDATE IGNORE:

update IGNORE bccontacts 
set mobile_no='919727048248' 
where mobile_no=09727048248

More info here: http://dev.mysql.com/doc/refman/5.0/en/update.html