update replace command in mysql

Question

All,

In a field named(path) in The table named is recn i have the follwoing data /home/user1/Computer-Science-10_1-10_7-17//html/Compu.html

how do i replace

/home/user1/Computer-Science-10_1-10_7-17//html/Compu.html with /home/user1/path/files/Computer-Science-10_1-10_7-17//html/Compu.html in mysql

Also There are many rows like /home/user1 which i have to replace with /home/user1/path/files

Thanks.....

Answer 1

Is this what you want?

UPDATE mytable SET mycolumn 
  = REPLACE(mycolumn, '/home/user1','/home/user1/path/files');