MySQL REPLACE error? "A new expression was found, but without a separator"

I am trying to replace the substrings in the fields of the table, but phpMyAdmin says โ€œA new statement was found, but there was no separator between it and the previous oneโ€ (near REPLACE) โ€œI looked through the documentation but did not find any hint of what I could do. Also Web search gives no useful results ...

My statement:

update phpbb_users
SET user_avatar = REPLACE(user_avatar, 'http://', '//') WHERE user_avatar LIKE ('http://%');

I get a similar error message when I try using

update phpbb_posts
SET post_text = REPLACE(post_text, 'http://', '//') WHERE post_text LIKE ('http://');
+4
source share
1 answer

() phpMyAdmin; , , 4.5.5.1, , , , , .

+4

All Articles