title: MySQL If exsists insert into or else do something else
body: <p>I'm having some difficulty putting a conditional into MySQL. I've been trying to create a query that will go through all of the column titled email and if it exists I want to do something like this:
  If an email exists I want it to take the existing value of the column correct and add the php variable $correct to it. But if an email does not exist then I want it to add a new record with the values $email into the column email and $correct into column correct.  Any help would be greatly appreciated.<br>
  Here's what I have and does not work:</p>
  
  <pre><code>IF  (SELECT * FROM facebookqs WHERE email = '$email' &gt; 0)
  UPDATE facebookqs SET correct = correct + '$correct' where email ='$email' 
  Else
  Insert into facebookqs (email, correct) VALUES ('$email', '$correct')
  </code></pre>