Page 1 of 1

need 2 select only selective data from a column and update

Posted: Tue Jun 24, 2008 6:23 am
by a3venom
hi ,
i own a mmorpg(online role playing game) server and all the data about each player is stored in a dbase name "ASD" in a table named "charac0" and column m_body
for example
here is the m_body for a particular player -
EXP=7413157\_1SKILL=4290723646;2147483648;0\_1PK=0\_1RTM=0\_1SINFO=131072\_1WEAR=2071;2337;1209798488;3341;3105;438177624;36099;4129;2573078360;3336;5153;3530166104;3351;6177;3501854552;3346;7217;2549092184\_1INVEN=\_1PETINV=\_1CQUEST=1;0;0;0;0;0;0;0;1\_1W
leaving aside all the other part
i just want to edit EXP for this player making it EXP=0\ **** .
so i would like 2 ask is there any command for this or a function
as i evry player has different values of xp , skill etc i cannot create manual function fr each one.
i just want to know if i can edit only the EXP part.
thanks in advance :)
:?