Re: update statement

Hi, >I got a series of string value in this format ie: 1,2,3, say pretend that these are telephone number, which is one feild >in user table. >I need to update this telephone number field, I got 3 user ID in series like this too, ie: 3,4,5 and normally it is like > >update set .... where userID IN (3,4,5) ( when there is one vaule to update, not series of string to update). I would think about the general layout of the DB. It is not good to store more than one value in one field. Do some normalisation on your DB or read: http://www.devshed.com/Server_Side/MySQL/Normal/ and http://www.devshed.com/Server_Side/MySQL/Normal2/ hope it helps Johannes