update ubbt_POSTS set POST_POSTER_IP='x.x.x.x' where USER_ID='y'

x.x.x.x = the new IP

y = the user id of the user to be changed.