how to do this with pure mysql?

Question

If mysql record with condition exists-update it,else create new record

Answer 1

Are you looking for INSERT ... ON DUPLICATE KEY UPDATE?

Answer 2

Is this what you're looking for?

INSERT INTO table (a,b,c) VALUES (1,2,3)
  ON DUPLICATE KEY UPDATE c=c+1;

http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html

Answer 3

Use REPLACE instead of INSERT.

Answer 4

You can use the REPLACE INTO for that with the syntax of INSERT INTO. This way MySQL will invoke an UPDATE whenever there's a fictive constraint violation.

Be aware that this construct is MySQL-specific, so your query ain't going to work whenever you switch from DB.