Update or insert db row based on non unique column

Asked Feb 09 '23 at 17:36

Active Feb 13 '23 at 12:44

Viewed 48 times

I am in need to insert a row in a table if it does not exist, or update it otherwise, but based in a column that is not unique or primary.

I am doing the insert part with :

INSERT INTO table (`match`, `to`, `status`, `type`, cat, rel, tag) VALUES ('$match_tag', '$match_tag_url', '1', 'redirection', 'confirmed', '', '$tag')

but if match exists already I'd like to update the to value, all in one query if possible.

I apologise in advance for the novice question and thank everyone for any input.

I am thinking the solution might relate to the ON DUPLICATE KEY UPDATE statement, but all the examples I have found so far involve a unique or primary item which I do not have in my case.

edited Feb 11 '23 at 22:48

SelVazi

10,028
2
13
29

asked Feb 09 '23 at 17:36

Panos

https://stackoverflow.com/questions/42663074/is-merge-statement-available-in-mysql – Randy Feb 09 '23 at 17:47
If `match` is non-unique, and there are ***two*** existing rows that match the row you're inserting, which row should be updated? – MatBailie Feb 13 '23 at 12:47
You need `REPLACE`. – syck Feb 13 '23 at 14:10

Update or insert db row based on non unique column

0 Answers0