title: INSERT ON DUPLICATE KEYs
body: <p>How would I insert a row or update a row, if the matchid and videoset fields are equal to the current value?
  This is what I have so far and I would expect if I ran this twice on an empty table, 3 rows of results should be the total amount returned. When I run this query twice, it does not update the 3 records added previously like expected, the query will simply add another 3 results. Any knowledge in this area would be highly appreciated. Thanks!</p>
  
  <pre><code>INSERT INTO videos (matchid, youtubecode, videoid, videoset) VALUES
  (96, "Blahblahblah", '', '1'), 
  (96, "WEEEEEE", '', '2'),
  (96, "glgkgklbgjbgklbj", '', '3')
  on duplicate key update matchid=values(videoset) AND videoset=values(videoset)
  
  
  /*Column Information*/
  ----------------------
  
  Field        Type          Collation          Null    Key     Default  Extra           Privileges                       Comment  
  -----------  ------------  -----------------  ------  ------  -------  --------------  -------------------------------  ---------
  matchid      int(10)       (NULL)             YES     MUL     (NULL)                   select,insert,update,references           
  youtubecode  varchar(300)  latin1_swedish_ci  NO              (NULL)                   select,insert,update,references           
  videoid      int(11)       (NULL)             NO      PRI     (NULL)   auto_increment  select,insert,update,references           
  videoset     int(11)       (NULL)             YES     MUL     (NULL)                   select,insert,update,references           
  
  /*Index Information*/
  ---------------------
  
  Table   Non_unique  Key_name  Seq_in_index  Column_name  Collation  Cardinality  Sub_part  Packed  Null    Index_type  Comment  Index_comment  
  ------  ----------  --------  ------------  -----------  ---------  -----------  --------  ------  ------  ----------  -------  ---------------
  videos           0  PRIMARY              1  videoid      A                    6    (NULL)  (NULL)          BTREE                               
  videos           1  matchid              1  matchid      A                    2    (NULL)  (NULL)  YES     BTREE                               
  videos           1  videoset             1  videoset     A                    6    (NULL)  (NULL)  YES     BTREE 
  </code></pre>