How to wildcard in replace?

Discussion in 'MySQL' started by FlexiHost, Jun 3, 2010.

0
  1. #1
    I am wanting to bomb one row, and reset all values to 0. How can I do this? I have tried % and * in there, but no go. Any suggestions?

    UPDATE photo_package SET code = replace(code, "wildcard", "0")
     
    FlexiHost, Jun 3, 2010 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    To reset every value in the column to 0, you would use this.


    UPDATE photo_package SET code = '0';
     
    jestep, Jun 4, 2010 IP