WP Metadata: Convert image URL to image ID

wp_meta_image_url_to_id.sql

# Below SQL will convert an attachment URL to the attachment ID
# Useful when switching from Toolset to Pods or ACF.

UPDATE wp_postmeta m
	LEFT JOIN wp_postmeta s
		ON INSTR( m.meta_value, s.meta_value ) > 0
	SET m.meta_value = s.post_id
	WHERE
		s.meta_key = '_wp_attached_file'
		AND m.meta_key = 'YOUR_META_KEY'