Replace special chracters in mySql DB field

Discussion in 'MySQL' started by versus2, Jul 22, 2007.

0
  1. #1
    Hi,

    I need to replace all " and ' characters in a field i have (mysql database).

    This field's name is "short_desc" and its type is "text". I'd like to do it by running an sql query via phpMyAdmin on all the data it contains.

    " should be replaced with "
    I think that ' should be replaced with ’ (right?)

    What query should i run to do that ?

    Thanks,
    E-A.
     
    versus2, Jul 22, 2007 IP
  2. versus2

    versus2 Well-Known Member

    Messages:
    796
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    110
    #2
    figured it out.. thanks
     
    versus2, Jul 22, 2007 IP