Skip to content

Instantly share code, notes, and snippets.

@andrewlimaza

andrewlimaza/update-users-start-date.sql

Last active November 27, 2020 12:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save andrewlimaza/97b86cbda2e19350a6cb0a77c91922e4 to your computer and use it in GitHub Desktop.
Save andrewlimaza/97b86cbda2e19350a6cb0a77c91922e4 to your computer and use it in GitHub Desktop.
Download ZIP
SQL to update a specific user's start date [Paid Memberships Pro]
Raw
update-users-start-date.sql
/**
* Please have a backup before running this script on your database
* Adjust the database prefix 'wp_' to match that of your database.
* You may alter the WHERE clause for any condition you would like.
**/
UPDATE wp_pmpro_memberships_users
SET startdate = '2020-01-01 00:00:00'
WHERE user_id = 1 AND membership_id = 3 AND status = 'active'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment