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