SQL querry help – replace certain words in every post

  • Resolved priyank

    (@priyank)


    17 years, 9 months ago

    Hi,

    I recently moved to a linux server as a result of which all my image filenames are now suddenly lowercase. I did not envision this before, so now I have to rename each instance “JPG” with “jpg” and “IMG” with “img” – across all my posts.

    Since I have to make this change anyway, I also thought of modifying the image gallery address from say “gallery/set1” to “gallery/category1/set1”

    Can anyone help me with SQL query to make such blog-wide change? I have no programming experience but I can read and play with the querries to suit.

    Thanks in advance,
    Priyank

Viewing 1 replies (of 1 total)
  • Thread Starter priyank

    (@priyank)

    17 years, 9 months ago

    Hi,
    I found it say
    UPDATE wp_posts SET post_content = REPLACE (post_content, ‘.JPG’, ‘.jpg’);

    pretty simple 🙂 Thanks.

Viewing 1 replies (of 1 total)

The topic ‘SQL querry help – replace certain words in every post’ is closed to new replies.

Tags