I've made a large mess and need to fix it. It's a "find this" and "add it once more, but above it, in that same field" dealio in one single tables field in mysql. "This" is a different string every time. Not sure this can be done with mysql, so I'm open to all other ideas.
Ok, so I have a badly created embed and object tag code all saved in one mysql field lets call it 'body'. I'm doing the embed like the example at the bottom of this apple page
Body has other data/info before and after the embed and object tags so 'body' can vary greatly in length.
The Object tags calls the quicktime codebase, and underneath that we have the
param name= stuff
but we lack
linking to a file! Below the param name comes the
embed src=link to file!
tag. So, what we want to do is get that link from embed, in each individual 'body' field, and create a
param name src
with the same link
and add this to this same 'body' field.
Each link is different, obviously, and we're talking 45,000 entries which is why I am scratching my head how to do this. Is there a way to, say,
add (wildcard) where like%
solution I could do, I'm stumped?