Skip to content

Instantly share code, notes, and snippets.

@andrewlimaza

andrewlimaza/update-sponsored-members-discount-code.sql

Created October 29, 2020 15:16
Show Gist options
  • Save andrewlimaza/bb640f91416bd7fd2979850973ff6200 to your computer and use it in GitHub Desktop.
Save andrewlimaza/bb640f91416bd7fd2979850973ff6200 to your computer and use it in GitHub Desktop.
Download ZIP
Bulk update expiration date for existing Sponsored Members Discount Code
Raw
update-sponsored-members-discount-code.sql
/**
* Please have a backup of your database before running this code.
* Adjust your 'wp_' prefix to match that of your WordPress database.
* This works only with mySQL databases.
*
* Adjust the expiration date by 10 years for all discount codes starting with "S".
*/
UPDATE wp_pmpro_discount_codes SET `expires` = DATE_ADD(expires, INTERVAL 10 YEAR) WHERE `code` LIKE 'S%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment