|
Hmm... unless an easier way:
UPDATE post SET pagetext = REPLACE(pagetext, '/data/500/','/data/500/medium/') WHERE pagetext LIKE '%-med.jpg%'
UPDATE post SET pagetext = REPLACE(pagetext, '-med.jpg','.jpg')
That should stop all the normals getting hit...
|