title: Update MySQL table and ignore duplicate entries
body: <p>I created a table that contains a UNIQUE 'mobile_no' like</p>
  
  <pre><code>09727048248
  9727048248
  9824578564
  9898998998
  </code></pre>
  
  <p>Then I am going to check whether or not the mobile number is valid, and if it's valid then I want to change it into the proper format like 919727048248.</p>
  
  <p>For that I called update query like..</p>
  
  <pre><code>update bccontacts 
  set mobile_no='919727048248' 
  where mobile_no=09727048248
  </code></pre>
  
  <p>The first time it ran successfully, but the second time it replied</p>
  
  <blockquote>
    <p>ERROR 1062 (23000):Duplicate entry '919727048248' for key 'mobile_no'</p>
  </blockquote>
  
  <p>Because there is already a unique key set for the 'mobile_no'.</p>
  
  <p>So is there any other query which will <code>IGNORE DUPLICATE KEY ON UPDATE</code>?</p>