Tell us what you are trying to do?
I would like to create a query to copy address data from one table into the table that stores the Toolset custom fields. The toolset custom fields I created need to be filled with that address data. The address data in the other table was stored by a different WordPress plugin.
What database (DB) tables store the custom fields?
Hello. Thank you for contacting the Toolset support.
Basically, Toolset store the custom field data as per the WordPress standard.
The post custom Address fields values are stored into the postmeta table with metakey and metavalue.
In addition to that, Toolset stores the address to custom table namely: toolset_maps_address_cache
However - with latest version of Map we offer a button at Toolset => Settings => Maps tab => "Cached data" section and you can click on the button "Check for missing cache entries" this will automatically add the missing address field entries to the cache table.