title: Insert multiple values and ignore duplicates on not key field
body: <p>If I want to insert multiple values to a table with fields:  </p>
  
  <pre><code>ID | name | content  
  ---+------+------------------
   1 | john | some content  
   2 | bob  | another content
  </code></pre>
  
  <p>and now I want to insert multiple values:  </p>
  
  <pre><code>INSERT INTO persons (name,content)
  VALUES
  ("Foo","meh"),
  ("Moo","beh"),
  ("bob","huh"),
  ("dude","haha")
  </code></pre>
  
  <p>that the result should be:</p>
  
  <pre><code>ID | name | content  
  ---+------+------------------
   1 | john | some content  
   2 | bob  | another content
   3 | Foo  | meh
   4 | Moo  | beh
   5 | dude | haha
  </code></pre>
  
  <p>The query ignores duplicates by name so "bob"|"huh" is not inserted, the name is not a key field. I can't find anywhere the syntax for this, I know it should be something simple.</p>
  
  <p>I'm using MySQL database.</p>