insert or update

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


Sponsor our Newsletter | Privacy Policy | Terms of Service