Just a little question about mysql and forgive me if this is the wrong place to ask this.
I use the follwing query to inset/update a value if the steamid is already present in the table. (SteamID is primary)
INSERT INTO Table (SteamID, Credits) VALUES ('123', '123') ON DUPLICATE KEY UPDATE Credits = VALUES(Credits)
However, I want to check if both steamid and another column exist together and then update the value as before. For example if Steami(123) and Credits(123) are present in the same row then update another value within that row. I just have no idea really on how to do it.