you need ""'s to signify the start and end of content as there are .'s in the line, you don't need ""'s on the userid as there is no additional information.
If you want to get ultra anal with a query then:
UPDATE `ubbt_POSTS` SET `POST_POSTER_IP` = '9.9.9.9' WHERE `USER_ID`='100000';