Member Avatar for cheekycroak

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

  • 2 Contributors
  • 2 Replies
  • 139 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by crishlay
Member Avatar for cheekycroak

Below is the final code: UPDATE songlist SET listen = replace(listen, "D:\\Downloads\\Music\\", "http://mysite.com/Music/")

It worked like a charm!!

Member Avatar for crishlay

in Replace() function you must give some values in place of existing values

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.