In this table scheme [id - name - active] [1 - alex - 0 ] I have a `UNIQUE KEY` on `name, active`, What I'm trying to do is to `INSERT` a new Row `[2 - max - 1 ]` using `INSERT INTO table (name, active) VALUES (max, 1) ON KEY DUPLICATE active = 0` That I want to loop at `active` **column** value, If the `row:[2-max-1]` exists with `active=1` to change `active` value to `0` And if exists with `active=0` to change it to `1`, And if not exist to `INSERT` the row with `active=1` Can't figure out a way to make this loop using only `INSERT . . . ON KEY DUPLICATE UPDATE`