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

  1.
    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
    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.
      0
      1. yg_be Posted messages 23437 Registration date   Status Contributor Last intervention   1 588 > Thibaut
         
        et '\;' ?
        0
      2. Thibaut > yg_be Posted messages 23437 Registration date   Status Contributor Last intervention  
         
        Already tried unfortunately still in error...
        0
  2. jordane45 Posted messages 30427 Registration date   Status Moderator Last intervention   4 832
     
    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
  3. Thibaut
     
    Great, it worked! Thank you very much.
    0