Escaping semicolon in phpmyadmin

Question

In PHPMyAdmin I want to replace "aa;bb" -> "aabb", by running the query:

UPDATE `question` SET `text` = REPLACE(`text`, 'aa;bb', 'aabb') WHERE INSTR(`text`, 'aa;bb') > 0;

but I get an error:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''aa)' at line 1

The error occurs always I put a semicolon in the string. Also, the semicolon does not work in searh or find and replace in PHPMyAdmin.

Answer 1

The error occurs always I put a semicolon in the string. Also, the semicolon does not work in searh or find and replace in PHPMyAdmin

Try this:

UPDATE `question` SET `text` = REPLACE(`text`, 'aa\;bb', 'aabb') WHERE INSTR(`text`, 'aa;bb') > 0;

Answer 2

I had to change the delimiter from a semicolon to something else, I used a vertical bar.