title: MySQL append , prefix a range of numbers with 0
body: <p>I have around a few thousand rows with which contain 3 digit numbers starting with 100 and ranging to 199 which i need to prefix with 0. There are also thousands of other numbers 4 digit numbers as well which i don't want to change.</p>
  
  <p>I need find all the 3 digit numbers in the range and prefix only those ranging from 100 -199 with a 0 so as they are 4 digits eg 100 > 0100 , 104 > 0104 and so on.
  Also these numbers may step eg 110 next is 124.</p>
  
  <p>Is there a way I can do this using SQL? as i don't fancy changing these manually!</p>
  
  <p>Many Thanks</p>