Basically we have something called DOI for articles which are unique for each article. It looks like this 10.3311/euro.xx/xxx.yyyy
We have 2 slashes in the DOI, but i want to replace the 2nd slash with a dot(.) Using REPLACE query can we solve this problem? If yes, could you please send me an example query so that I can customize it for my application.