title: MySQL Changing from Null to Non Null
body: <p>I have got a field that has been setup to allow for Null, but am now wanting to change that to not allow for Null. </p>
  
  <p>When ever I try to change this I can't because PhpMyAdmin has set all the previous records to Null.</p>
  
  <p>How can I fix this problem? </p>
  
  <p>Is there a query I could put that will remove all the Null values and set the field to Non Null? </p>