hi,

I would like to know how i can easily replace all (for example) '/kgk/site/uploads' with '/uploads' in all fields named 'text' in the table 'content'. Can this be done?

This is because i am preparing my websites on my own server, where they are located in a subfolder of root, but once i upload them they are in the root.

thanks!

Matt

UPDATE `content` SET `text`=replace(`text`, '/kgk/site/uploads', '/uploads');

Not tested. I don't know how the backtick is used in the case of a function call, so try it before updateing

--update myTable
--set `text`=case 
--    when locate('/kgk/site')>0 then replace(`text`,'/kgk/site','')
--    else `text`
--  end;

select `text`,case
    when locate('/kgk/site')>0 then replace(`text`,'/kgk/site','')
    else `text`
  end as cleaned
from myTable;

thanks, will try!