need 2 select only selective data from a column and update

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
a3venom
Forum Newbie
Posts: 3
Joined: Fri Jun 20, 2008 11:52 pm

need 2 select only selective data from a column and update

Post 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 :)
:?
Post Reply