select least(`notoriety` * 0.2 + 6, 200) as maximum from `mm_master` where `mid` = '10' select sum(`number`) as count from `mm_minion` where `master_id` = '10' then i have some if's if (`count` =< `maximum` - 6){ addme = 6 }elseif (`count` < `maximum`) { addme = `maximum` - `count` } then insert into `mm_minion` (`mid`,`number`) values ('10',`addme`) on duplicate key update `number` = `number` + `addme` where `master_id` = '10' ##### `notoriety` is between 1 and 1000 `number` is between 1 and 200