I use this in phpmyadmin to enter data into the database, i know it works right, but i have a question about replacing or updating
here goes
INSERT INTO users (id,mwid,username,level,team,defwin,deflose,notes) VALUES
(148687346, ‘100000148687346’, ’ Bang Mike’, ‘903’, ‘51’, ‘5611’, ‘100’, ’ notes’)
My question is this, how can i make it so if the id already exists it will update the username,level,team,defwin( If the new # is greater),deflose( If the new # is greater)
I have searched and cannot find this answer, i appreciate your help