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.....

davek · Accepted Answer · 2010-02-01 07:23:13Z

5

Is this what you want?

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

davek

23k11 gold badges80 silver badges97 bronze badges

answered Feb 1, 2010 at 7:15

Max Shawabkeh

38.7k10 gold badges85 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1