In Need of mySQL Expert!

  • Hi.

    I have a problem with a new plugin I’m using. Apparently it requires that every img tag I used must be contained within “. I have over hundreds of wp posts that contain images without “. For example:

    It requires: img src=”https://example.com/example.jpg”

    But I have: img src=https://example.com/example.jpg

    Is there anyway to use mySQL to run through all my entries and change every

    src=https:// into src=”http:
    and
    .jpg into .jpg”

    Can I do this in mySQL? Can someone show me how? I don’t know how to use mySQL that well. Thanks for anybody’s help.

Viewing 1 replies (of 1 total)

  • The easy explanation: Backup your database. Export the data from mysql into a text file. Do a search and replace on the text file and re-upload the text file to replace the info on the server.

    The harder explanation: If you don’t know how to do all of the above, post again and I or some other soul can explain. it’s a lot of typing if you already know.

    Thanks
    Steve

Viewing 1 replies (of 1 total)
  • The topic ‘In Need of mySQL Expert!’ is closed to new replies.