0

Trying to get specific orders by the customer ID via a raw SQL query. I'd like to input which order IDs I'd like to retrieve, but only retrieve them if they match a specific customer ID, here's what I have so far:

SELECT *
FROM wp_postmeta
WHERE post_id IN ($order_ids)
AND (meta_key='_customer_user' AND meta_value='$user_id')

I've read some things similar but nothing doing exactly as I need it to.

Any help would be greatly appreciated. Thanks in advance.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.