I'm trying to find a way to replace part of a string in a database without knowing the exact substring content other than how it starts, ends and has a specific ID string somewhere in between that.
To specify, I have Vimeo iframes that are within post content inside a column in a MySQL database table. I need to replace all vimeo iframes strings in this column over to another video platform script. I have a list to use containing the Vimeo IDs and the new code to go in place of the existing Vimeo iframe, so this gives me a unique identifier to use when searching.
The problem is, some of the Vimeo urls have additional GET queries added to the URL so I can't do a 1 for 1 match of the Vimeo iframe.
I do know for certain that each iframe instance I need to replace will begin with
<iframe, end with
</iframe> and contain a specific Vimeo ID (ie
1234567). Is there a way to do this with Regex and concat or something similar so that I can replace the entire iframe code with a new string?