Re: searching for windows paths

[Private Citizen]

Well, so I can select the rows. But what I really want to do is change the paths that begin with such-and-such (e.g., "c:\psoc\") to prepend something like this: "c:\projects\". And I have tried a few things, but nothing works so far. I have even tried replacing the whole path, like this:

UPDATE myschema.modules
SET path = REPLACE(path, "c\:\\\\psoc\\cy8cproj1\\",
"c\:\\\\projects\\psoc\\cy8cproj1\\");

No rows are updated, but about 45 a returned for the SELECT query on "c\:\\\\psoc\\cy8cproj1\\".