The Little Guy Posted August 12, 2008 Share Posted August 12, 2008 I need an update code that will take the column "points" and take 15% of the score off. So if the score is: 1000 when the update runs, the users new score will be: 850 Anyone know how I could do this? Quote Link to comment Share on other sites More sharing options...
toplay Posted August 12, 2008 Share Posted August 12, 2008 update table_name set column_name = column_name * 0.85 where .... Quote Link to comment Share on other sites More sharing options...
The Little Guy Posted August 12, 2008 Author Share Posted August 12, 2008 I actually got this, and it works: ((`points`) - (`points` * 0.15)) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.