Mysql on duplicate key condition (IF) setting of one field
I am using on duplicate key to update data in a mySQL DB v 8.0.35 (AWS RDS instance) I want to update a selection of fields with the new value. Plus set a further field (up[dated) to 1 only if…