Need help with SQL query

[Anon]

Hi, I have a MySQL table that contains a column of email addresses that all begin with "webmaster@". I want to replace the "webmaster@" with "http://www." Does anyone know how to issue a update or other type query to do this? Thanks.

[Anon]

if this is a one time thing, it seems like it would be easier to write a little PHP script to do that. Simpler than trying to do it all in one query (if thats possible).

[[deleted]]

It's not that difficult is it?

just one update query with a 'replace()' to change the string...

something like

UPDATE table
set email = replace(email,'webmaster@','http://www.');

Make a backup of your data first!!!

have a look at 'replace()'
http://www.mysql.com/doc/S/t/String_functions.html

[Anon]

you may try this
update <table_name> set <column_name> = "http:// www.." where <column_name> = "webmaster@."

[Anon]

Thanks for the info - it worked perfect!

[[deleted]]

...uhm.... ya.