Forum Moderators: open

Message Too Old, No Replies

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

         

Dreap

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

10+ Year Member



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.

Dijkgraaf

1:34 am on Mar 18, 2010 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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.