Mass update PaymentMethod (paymentmethod)

[Colin N.]

Hello,

I currently use banktransfer, paypal and paypalexpress payment methods and have done for some years without issue.

Recently i've signed up to Stripe and now I want to change all domains/hosting service to use Stripe in cases where there is no paypal subscription.

Would the following SQL statements do the trick?

# update all active domains
UPDATE tbldomains SET paymentmethod = 'stripe' where status = 'Active' and ( paymentmethod = 'paypal' or paymentmethod = 'paypalexpress' );

# update all active services without a subscriptionid
UPDATE tblhosting SET paymentmethod = 'stripe' where domainstatus = 'Active' and ( paymentmethod = 'paypal' or paymentmethod = 'paypalexpress' ) and subscriptionid = '';

Thanks in advance for your support,

Colin.