SQL replace does not work with phpMyAdmin?

1 Views

I’d like to replace an url in my WordPress database, but phpMyAdmin won’t perform my sql code 

UPDATE wp_posts 
SET post_content = replace (post_content, 'http://www.domain.de' , 'http://localhost/wordpress'); 

UPDATE wp_postmeta 
SET meta_value = replace (meta_value, 'http://www.domain.de' , 'http://localhost/wordpress');

All I get is

Read More

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘’ at line 1

I checked the SQl syntax but for me it seems to be right, could it be a problem with phpMyAdmin? (I am running 4.5.1)

Post Views: 1

Related posts

1 comment

  1. Posting as a community wiki.

    As stated in comments:

     is also ZERO WIDTH NO-BREAK SPACE, so it would be invisible. – Rick James

    Reference:

    “The name BYTE ORDER MARK is an alias for the original character name ZERO WIDTH NO-BREAK SPACE (ZWNBSP). With the introduction of U+2060 WORD JOINER, there’s no longer a need to ever use U+FEFF for its ZWNSP effect, so from that point on, and with the availability of a formal alias, the name ZERO WIDTH NO-BREAK SPACE is no longer helpful, and we will use the alias here.”

Comments are closed.