Hi there, I'm trying to fetch data from a Wordpress database into MS Access. In picture below you'll see how Woocommerce (the shop plugin of Wordpress) stores user data. I'm now trying to build a query to fetch the different user data at once (e.g. _billing_first_name, _billing_last_name, _billing_email, _billing_phone, _billing_city). They always have a common order ID. Of course, I could use single selects such as:
As I need quite a lot of data, I'm wondering if I can pull the data at once. Thanks for help.
Frank
Select meta_value from wp_postmeta where orderID = " & ID_woo & " and meta_key IN ('_billing_first_name')"
As I need quite a lot of data, I'm wondering if I can pull the data at once. Thanks for help.
Frank