mysql - Doctrine: ON DUPLICATE KEY UPDATE

Question

How can I write an INSERT doctrine query with option ON DUPLICATE KEY UPDATE?

Answer 1

for Symfony 2 use raw sql:

$em->getConnection()->prepare("INSERT INTO table SET 
    some_fields = "some data", created_at = NOW() 
    ON DUPLICATE KEY UPDATE
    some_fields = "some data", updated_at = NOW()
")->execute();