title: How to set default enum value if we insert a invalid enum value in MYSQL?
body: <p>I have a table </p>
  
  <pre><code>CREATE TABLE `enum_test` ( 
  `id` int(10) default NULL, 
  `value` enum('YES','NO') NOT NULL default 'YES' 
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  </code></pre>
  
  <hr>
  
  <p>then execute below query</p>
  
  <pre><code>INSERT INTO enum_test(id) VALUES (2);  set 'YES' in `enum` field.
  INSERT INTO enum_test(id,value) VALUES (2,1);  set 'YES' in `enum` field.
  </code></pre>
  
  <hr>
  
  <p>But</p>
  
  <pre><code> //why below query set blank value in enum field??  
    INSERT INTO enum_test(id, value) VALUES (2, 'YESS');
  </code></pre>
  
  <p>I want that if a user insert a value that does not exist in <code>enum</code>  field then it shoud set the default value of <code>enum</code>
  how to do that?</p>