The 2 table definitions are exactly the same, one is just an older backup I have.
Im trying to do it per record, I updated the first post a bit with a better description.
My table structure is something like:
quote:
CREATE TABLE `upgrades` (
`steamid` varchar(20) NOT NULL DEFAULT '',
`vip` tinyint(1) NOT NULL DEFAULT '0',
`playerupgrade1` int(5) NOT NULL DEFAULT '1',
`playerupgrade2` int(5) NOT NULL DEFAULT '1',
`playerupgrade3` int(5) NOT NULL DEFAULT '1',
`playerupgrade4` int(5) NOT NULL DEFAULT '1',
`playerupgrade5` int(5) NOT NULL DEFAULT '1',
`playerupgrade6` int(5) NOT NULL DEFAULT '1',
`playerupgrade7` int(5) NOT NULL DEFAULT '1',
`playerupgrade8` int(5) NOT NULL DEFAULT '1',
`upgradepoints` int(5) NOT NULL DEFAULT '30',
`zombieupgradepoints` int(5) NOT NULL DEFAULT '10',
`bonusupgradepoints` int(5) NOT NULL DEFAULT '0',
`success` tinyint(1) NOT NULL DEFAULT '1',
`playermodel` varchar(255) NOT NULL DEFAULT ''
What I am looking to compare are the playerupgrade1-4 fields from each record if the difference is > 10.
/ 
