Skip to content

Instantly share code, notes, and snippets.

@felipeelia
Created October 21, 2020 18:47
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 felipeelia/2f15f2ce26c87c3a84dc5bff8db64c6e to your computer and use it in GitHub Desktop.
Save felipeelia/2f15f2ce26c87c3a84dc5bff8db64c6e to your computer and use it in GitHub Desktop.
[WordPress] Bump FB and Instagram oembed time
UPDATE
`wp_postmeta` pm
SET meta_value = 1924905600
WHERE meta_key IN
(
SELECT * FROM
(
SELECT REPLACE(meta_key, '_oembed_', '_oembed_time_')
FROM `wp_postmeta`
WHERE meta_key LIKE '_oembed_%' AND ( meta_value LIKE '%id="fb-root"%' OR meta_value LIKE '%class="instagram-media"%' )
) AS subquery
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment