title: Insert if Update row_count()=0
body: <p>I need to update a table row, but if it dont exist, it must be created.
  I´ve tried with that code but returns errors:</p>
  
  <pre><code>UPDATE creature SET name="Bip" WHERE guid = 1;
  IF ROW_COUNT()=0 THEN 
      INSERT INTO creature (guid, name) VALUES(1, "Bip"); 
  END IF;
  </code></pre>
  
  <p>I need to update before inserting, so i cant use "INSERT … ON DUPLICATE KEY UPDATE …"<br>
  Thats becouse i supose that Insert query will be skiped if ROW_COUNT is 0.</p>
  
  <p>What can i do to fix it?</p>