View original (French)

REPLACE on a semicolon

Solved
Thibaut -  
 Thibaut -
Hello,

Sorry, I couldn't find the space for SQL in the forum.

I'm looking to replace all semicolons in a table.

My current query: 

UPDATE `prstshp_product_lang` SET `description_short` = REPLACE (`description_short`, ';' , ' ')



But the ";" is causing issues....

Any ideas?

Configuration: Windows / Chrome 97.0.4692.99

3 answers

Answer 1 / 3
yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   Ambassadeur 1 588
 
Hello,
which software are you using?
What is the problem with the ";"?
0
Thibaut
 
I'm doing this directly on phpmyadmin,
And everything works very well if I put any other character than the semicolon, but I get an error when I include it in the query.
0
yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   1 588 > Thibaut
 
et '\;' ?
0
Thibaut > yg_be Posted messages 23437 Registration date   Status Contributor Last intervention  
 
Already tried unfortunately still in error...
0
Answer 2 / 3
jordane45 Posted messages 30426 Registration date   Status Moderator Last intervention   4 830
 
Hello,

In PHPMyAdmin you need to modify the delimiter.

You can do it via a query 
 DELIMITER // UPDATE `prstshp_product_lang` SET `description_short` = REPLACE (`description_short`, ';' , ' ') DELIMITER ;


Otherwise, in the query execution tab, you have an option to change it manually if needed during your query

--
.
Sincerely,
Jordane
0
Answer 3 / 3
Thibaut
 
Great, it worked! Thank you very much.
0