How replace content (string) in a LONGTEXT?

petitof · #1 (**permalink**) 06-17-08, 05:13

I tried without any result with:
update table1 set col1=REPLACE(col1,'string ko','string ok');

Have you any idea to do that?

Thank you very much!
Fabio

r937 · #2 (**permalink**) 06-17-08, 06:21

what does "without any result" mean?

did the query run, or produce an error message?

petitof · #3 (**permalink**) 06-17-08, 06:32

I fix it, the problem was that I trid to replace "windows path":
KO -> REPLACE(col1,'D:\www\1','string ok');
OK -> REPLACE(col1,'D:\\www\\1','string ok');

thank you, @r937!:-)

Internet Services

Web Development

Digital Marketing

Consumer Tech