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://');
source
share