I have a database with 3 tables that need data updating
IN all three cases, the tables have a reference to an id in another table, and i need the name of the value brought in from the other table to replace the ID value in the inital table.
IN clf_business table in COUNTRY Field ID = 182634749
IN Locations table, Id 182634749, Name = Australia
in clf_business table replace 182634749 with AUstralia
fields that need matching and replacing are
Add a new field "Flex_Image"
then match Flex id in table "Images" and populate the Flex_Image Field with the image url from Images table
Replace All Ids, with Names from Flex table
See video here [url removed, login to view]
Immediate start, i want this job finished today don't apply if you cant achieve this