vbulletin mysql string change user IP

hi guys...

I'm selling my forums but i want to change the admin user ip address on every post etc. before i make the transfer
is there a string mysql query that i can run to change ipaddress for user admin on every post instead of going
around doing it manually which is like 2500 posts......?

this is for vbulletin

 

I don't know the table/db structure of vbulletin. Query may be something like

UPDATE table_name
SET ip_address = 'new IP address'
WHERE ip_addpress='admin_ip_address'

Code (markup):

This is a sample query, you need to replace appropriate columns and values.