Skip to content

Instantly share code, notes, and snippets.

@mrkdevelopment

mrkdevelopment/db_edit

Created January 14, 2025 04:00
Show Gist options
  • Save mrkdevelopment/53afd13150249f177465806da02fde50 to your computer and use it in GitHub Desktop.
Save mrkdevelopment/53afd13150249f177465806da02fde50 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Snippet
Raw
db_edit
UPDATE `wp_postmeta`
SET `meta_value` = null
WHERE `meta_key` LIKE '_job_expires'
AND `post_id` IN ( SELECT `post_id` FROM `wp_postmeta` WHERE `meta_key` LIKE '_case27_listing_type' AND `meta_value` LIKE 'places' )
AND `post_id` IN ( SELECT `post_id` FROM `wp_postmeta` WHERE `meta_key` LIKE '_featured' AND `meta_value` = '0' );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment