update statement
| From: | Jacky | Date: | Fri, 11 May 2001 15:00:07 +0000 |
| Subject: | update statement | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-52388@lists.php.net to get a copy of this message | ||
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).
How do I do that with this case then?
cheers
Jack
jacky@activelifestyle.com
"There is nothing more rewarding than reaching the goal you set for yourself"