var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: int % reduction
Hello, could somebody correct my query please?
I am trying to reduce the mob level in a given region by 60% using the following :-
it returns no results although I have a matching region
UPDATE `mob` SET Level = round(x*.4,0) WHERE 'Region' = 'said region';
what does the x* represent and what is the data type of the Level column?
Originally Posted by DNance
The column in question is an int column. x represents the column name.
I want to reduce everything in the x column by 50% but obviously only whole numbers.
So a value of 14 would become 7, but what if a value is 1 or even 0 ?
Is this best just done with /2 ?
Select FLOOR(Bonus1 / 2) as divided, Bonus1 as old
Ok this gives the results I want
Now I need to work out how to SET :-