title: What MySQL field should I use for a Yes/No Checkbox value?
body: <p>I am using the MySQL table below.  I would like to add a field called <code>'subcheck'</code> that will be a yes/no value determined by the HTML form input <code>TYPE = CHECKBOX</code>.  What "type" should I give this new field?</p>
  
  <p>Thanks in advance,</p>
  
  <p>John</p>
  
  <pre><code>`submission` (
    `submissionid` int(11) unsigned NOT NULL auto_increment,
    `loginid` int(11) NOT NULL,
    `title` varchar(1000) NOT NULL,
    `slug` varchar(1000) NOT NULL,
    `url` varchar(1000) NOT NULL,
    `displayurl` varchar(1000) NOT NULL,
    `datesubmitted` timestamp NOT NULL default CURRENT_TIMESTAMP,
    PRIMARY KEY  (`submissionid`)
  )
  </code></pre>