WHERE clause ON DUPLICATE KEY

[vincekaribusana]

Hi I’m trying to execute an INSERT AND UPDATE ON DUPLICATE KEY just for a specific user ID, my primary key is privacy_id so far I’ve tried:

INSERT INTO privacy (privacy_id, user_id, privacy_ref, privacy_value)
                VALUES (:privacyID, :userID, :privacyRef, :privacyValue)
                ON DUPLICATE KEY UPDATE privacy_value = :newPrivacyValue
WHERE user_id = :storedUserID

But searching online I’ve discovere it is not possible to use WHE clause with ON DUPLICATE KEY UPDATE is there another way to achieve it? Many thanks

[rpkamp]

What is the primary key of the privacy table? If it is user_id then you can just drop the WHERE and keep the rest of the query AFAIK.

[vincekaribusana]

Hi @rpkamp

@vincekaribusana

my primary key is privacy_id