The Pronamic Pay plugin allows you to easily accept payments with payment methods like credit card, iDEAL, Bancontact and Sofort through a variety of payment providers on your WordPress website.
SELECT
ID,
post_content->"$.customer.name",
post_content
FROM
wp_2_posts
WHERE
post_type = 'pronamic_payment'
AND
post_mime_type = 'application/json'
AND
post_content->"$.total_amount.value" > 200
;
Nice to know:
Originally posted by @remcotolsma in https://github.com/pronamic/wp-pronamic-pay/issues/218#issuecomment-932111106