View original (French)

REPLACE on a semicolon

Solved
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

  1.  yg_be Contributor
    Hello,
    which software are you using?
    What is the problem with the ";"?
    1. 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.
    3. Thibaut
      @yg_beAlready tried unfortunately still in error...
  2. jordane45 Moderator
    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