title: MySQL Update if row exists, otherwise insert
body: <pre><code>INSERT INTO GameScoreTotal (
      `GameName`
      , `OverallScore`
      , `GraphicsScore`
      , `StoryScore`
      , `GameplayScore`
      , `TimeScore`
      )
  VALUES (
      'HomeFront'
      , '1'
      , '1'
      , '1'
      , '1'
      , '5'
      )
  WHERE GameName = 'HomeFront'
      ON DUPLICATE KEY
  
  UPDATE OverallScoreTotal = OverallScoreTotal + '1'
      , GraphicsTotal = GraphicsTotal + '1'
      , StoryTotal = StoryTotal + '1'
      , GameplayTotal = GameplayTotal + '1'
      , TimeTotal = TimeTotal + '1'
      , RatingCount = RatingCount + 1;
  </code></pre>
  
  <p>I am trying to update GameScoreTotal If we have something there otherwise insert. Any ideas?</p>