The Velawesomeraptor Himself (clayrobeson) wrote,
The Velawesomeraptor Himself
clayrobeson

Okay, MySQL Gurus, help a brother out...

I need to run this query on a database to replace relative image links with absolute image links so I can migrate data properly... but I can't figure out how to escape out all the naughty characters:

update POSTS set POST_CONTENT = replace(POST_CONTENT, ‘"/images/stories’, ‘"http://website.com/images/stories’);

I've got "/images set so that if they're already absolute, it will skip them instead of doubling the http://website.com in the url of the image.

Help?

me
Brainfried
Subscribe

  • Milestones, or lack thereof...

    So I was at the gym on Thursday when I had my official "You've lost 30 pounds" weigh in, and Theresa (my trainer) got really serious…

  • The hobby that dare not speak its name...

    So on a POSITIVE note (which I seem to share so few of recently), I've been seeing a trainer for the last year or so. Twice a week, 30 minutes a…

  • Feel the force...

    I may or may not have just scared off a raccoon that was outside my window with a lightsaber flashlight.

  • Post a new comment

    Error

    Comments allowed for friends only

    Anonymous comments are disabled in this journal

    switch
    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    Help
  • 8 comments