sql find and replace multiple records
Posted on 2008-10-04
i have the following search and replace sql:
set group_id = "GROUP_ID"
where users_id = "USER_ID"
I'm able to use this to update one single field for which I have entered a user id. but i would like to update multiple fields, how do I add more user ids to this code. would it be something like this??
set group_id = "group_id"
where users_id = "user_id-1","user_id-2"
your input would be most appreciated!!