title: Convert varchar string data to time format in mysql
body: <p>I need to convert varchar string data to time format in mysql.</p>
  
  <p>For example,</p>
  
  <p>I have a varchar column in table which stores time. The accepted values should be like 9:30 AM  or 1200 PM. But currently it has either blank values or it has values like 9.30am or 12:00</p>
  
  <p>There are many records like this, so cannot update manually. </p>
  
  <p>Ithere any work around or function or procedure to do so?
  please help.</p>
  
  <p>Thanks</p>