Hi everyone,

Can you please help me with this.

I am trying to replace a web address in a field of my Wordpress tables.

I am running the statment straight fromt he MySql phpmyadmin field:

update wp_posts set post-content = replace(post_content,'biofona.com' ,'backinactionuk.com');

I keep getting a syntax error, although I cannot work out why.

MySql version is: MySQL client version: 5.0.51a

Can you please point me in thr right direction?

Kind Regards,

Vinny

    If what's in your post here is accurate, you have a hyphen which should be an underscore in the first instance of post_content. If that's not it, what's the exact error message?

      You use both "post-content" and "post_content" in that SQL query. I'm guessing only one of those is correct.

      EDIT: Oops - NogDog beat me to it.

        Bloody hell, yes, it was the hyphen that should have been an underscore. Thanks NogDog

        Sorry about that, just couldn't see it.

          Write a Reply...