Welcome to WebmasterWorld Guest from 54.166.3.44

Forum Moderators: open

Message Too Old, No Replies

MySQL Update, need to rise data in second column field list.

     
11:03 pm on Mar 17, 2010 (gmt 0)

New User

5+ Year Member

joined:Mar 16, 2010
posts:16
votes: 0


I have two columns in my table.

1. username
2. data

In data column there is data like this

tptes 2190110 134 350 1220 175 255 400 270 0 180 100 40 735 100


I want to update by specifying username and how much to add to third number from left.

For example I want to add 50 then value 134 would become into 184. Also all other values stay untouched.

Please note that these values are always different to every user.
1:34 am on Mar 18, 2010 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:May 31, 2005
posts:1108
votes: 0


Why are you storing all those values in one column?

It would be much easier if you stored them in separate columns which are numeric.