php - SQL 替换不适用于 phpMyAdmin？

Question

我想替换我的 Wordpress 数据库中的 url，但 phpMyAdmin 不会执行我的 sql 代码

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');

我得到的是

#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

我检查了 SQl 语法，但对我来说似乎是正确的，会不会是 phpMyAdmin 的问题？ (我运行的是4.5.1)

Answer 1

作为社区 wiki 发布。

如评论中所述:

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

引用:

• https://www.w3.org/International/questions/qa-byte-order-mark

• 又名:字节顺序标记 (BOM)，但在这种情况下，让您失望的是零宽度不间断空间。

"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."