Thanks guys. I will probably make this person just a moderator with the ability to edit users, but he will still be able to view IP addresses...

So is this the exact command which I should type:

UPDATE ubbt_POSTS SET POST_POSTER_IP = "9.9.9.9" WHERE USER_ID =100000

Or do I need a space between {=} and {100000} ?

Also I have to put the IP in parenthesis, say "9.9.9.9" , but not the user ID, right?