Created
October 21, 2020 18:47
-
-
Save felipeelia/2f15f2ce26c87c3a84dc5bff8db64c6e to your computer and use it in GitHub Desktop.
[WordPress] Bump FB and Instagram oembed time
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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