When executing a sql query, an error # 1064 occurs, what's wrong?

Question

MySQL

When executing a request:

UPDATE wp_posts SET post_content = REPLACE (post_content, '99cc00;">Видео</span></address>', '');

There is an error #1064
As I understand it, this error is due to ;
the line 99cc00;">Видео</span></address>.

What to do with ;
If you remove ; the request will not be correct!!

Answer 1

In phpmyadmin, below the query window, there is a field "Delimiter ;"
Try to change there ; to something else, such as |