A Quick way of doing this?

Hello.

My Jobs Table has an Order_Site_Address which is filtered by Customer Name. The Order_Site_Address is selected from a sites table, which also has the Customer Name.

I need to change the information in the database, so the Order_Site_Address will now hold a LocationId from the sites table, but in the php project it will display the actual site address.

Is there a qucik way of applying this to 24000+ data entries?

Cheers

Paul.
Just another idea.
I can leave the Address in the Order_Site_Address as they are, but when we go to edit the page, is there anyway I can get the software to replace the value in the Order_Site_Address with the correct LocationId, but still display the Order_Site_Address?

Cheers