Whats wrong with this UPDATE function

[munnamian]

hi there

i need to delete the txt OLD in S_NAME but it shows error
anyone thx in advance

update Songs SET S_NAME = REPLACE () WHERE S_NAME = 'OLD';

 

[piulibero]

the error looks like:
"""The replace function requires 3 arguments."""
?

 

[LittleSmudge]

Whynot use

UPDATE Songs SET S_NAME = '' WHERE S_NAME = 'OLD';




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[munnamian]

not working..

 

[TonyGroves]

Just in case: that's 2 single quotes in S_NAME = ''.

It would be useful if you told us how it's not working. Is it rejecting your syntax (what error appears?), or does it give the wrong results (what does happen?)?

 

[munnamian]

It gives no error, it just shows 0 processed tables or whatever it shows (its in norwegian so dont know what it had in the english version) i remember i had something similar ages ago and it was something similar as in the command

And ya i am using the two single quotes

 

[TonyGroves]

Can you do a SHOW CREATE TABLE SONGS and post the result here?

 

[TonyGroves]

You can ignore my previous post, it probably won't help.

What exactly are you trying to do?

If you want to change S_NAME when it contains just the text 'OLD', then LittleSmudge's solution is perfect.

If you want to eliminate the text 'OLD' wherever it appears in the field, then use:
[tt]UPDATE songs SET s_name=REPLACE(s_name,'OLD','')[/tt]
or, if you want a record count:
[tt]UPDATE songs SET s_name=REPLACE(s_name,'OLD','') WHERE s_name LIKE '%OLD%'[/tt]

 

[munnamian]

thx will try that

 

[LittleSmudge]

Oh Good re-interpretation of the question Tony.

I wasn't comfortable that I was addressing the right issue but I couldn't see what else they might be trying to do.
I think you've seen through the fog now.





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.