unwanted characters, how to remove this?

[solidcodes]

hi guys

when i save the email address the value looks like this below,

anna_single16%40yahoo.com

it suppose to be anna_single@yahoo.com

Now how to i remove those nasty characters?

thank you very much in advance.

[r937]

UPDATE daTable
   SET email = REPLACE(email,'%40','@')
 WHERE POSITION('%' IN email) > 0

[solidcodes]

thanks 4937

But how about in INSERT?

[r937]

if it is getting converted during insert, it is not mysql's fault

what language are you using? php? that'll be where the problem is

[solidcodes]

yeah php

so what the command in php to clean that?

thank you.

[r937]

so what the command in php to clean that?

no idea, sorry, i don't do php

[steve2688]

as i know is INSERT mean fill in a new data into db....
if want to clear the whole row in sql,you need to used DELETE..