title: MySQL gender table field
body: <p>If I want to create a gender field in my table, how do I make sure that my database doesn't accept any value apart from "M" or "F" ?</p>
  
  <pre><code> $sqlCommand = "CREATE TABLE members (
               id int(11) NOT NULL auto_increment,
               ... 
               ...
               ...
               ...
               gender
               )";
  </code></pre>
  
  <p>Thank you</p>