title: Validate status of URLs in a mysql Database using CURL and shell script
body: <p>Good day,</p>
  
  <p>I have a simple MySQL database with 1 table and 3 fields  </p>
  
  <p>Table:  <code>LINKS</code><br>
  Fields: <code>ID</code> <code>URL</code> <code>STATUS</code></p>
  
  <p>The table has about 3 millions links.<br>
  I would like to check all the URLs and post their returned status in the status field so that I can remove the dead links later. </p>
  
  <p>This would probably require a shell script because it will need to run for a long time.<br>
  I think CURL headers may provide the best method for checking the status code, but I don't know how to put this all together. Any help on the above or a suggestion for a better way to handle this would be greatly appreciated. </p>
  
  <p>Thank you.</p>