Re: Only changing part of a field...

2001-02-24 Thread Tõnu Samuel
Marcus Ouimet wrote: > One quick question, I am trying just replace part of the entry ie: > change: > /image/covers/009.jpg > to > image/covers/09.jpg > > I have tried to update products set 'image/covers' where > products_image like '/images/covers%'; but it seems to replace the whole > field

Only changing part of a field...

2001-02-24 Thread Marcus Ouimet
One quick question, I am trying just replace part of the entry ie: change: /image/covers/009.jpg to image/covers/09.jpg I have tried to update products set products_image='image/covers' where products_image like '/images/covers%'; but it seems to replace the whole field and not leave the trai