mysql的url路径,将目录路径替换为mysql数据库表中的url路径

Dear all..before i give up after multiple trial and error attempts,can someone please help me with below query.

I am trying to replace the path name D:\Downloads\Music\ (note the slash) to http://mysite.com/Music/ in mysql field name called "filename" under "songlist" table.

Below is the query code that I tried with but nothing happens.It only gives me the following message : 0 row(s) affected. ( Query took 0.1428 sec )

UPDATE songlist SET filename = replace(filename, "D:\Downloads\Music", "http://mysite.com/Music/")

many thanks for the help!!!

解决方案Double backslash: replace(filename, "D:\\Downloads\\Music", "http://mysite.com/Music/")

Try putting @ before your text string paths.

Shouldn''t be single quote('') instead of double quote(")?