Replace Specific Characters in mysql PHP

[ZABI]

Hi all, I am working with a site with an old database having more than 2000 product entries... and most of the products have the article number as ASC-000-000-00

what i want to do is to replace these article numbers with DSC-000-000-00... I dont want to edit/update every entry for that... what I want is just a simple query or 3-4 PHP statements to accomplish,,, any ideas...

[jogol]

PHP str_replace() Function

[ZABI]

that's too funny... plz read my question again... i want to replace character(s) in mysql and records are more than 2000 ... so str_replace is useless there

[jogol]

either write a php script that does the following:
db query -> for each entry str_replace() -> update db

or export the db data to a txt file and use the search and replace function of an editor (e.g. Notepad++) and import the data into the db again.

[criterion9]

Maybe utilizing the built in string manipulation functions of the DB rather than some convoluted flat file hack as suggested...
http://dev.mysql.com/doc/refman/5.0/...functions.html

[jogol]

something like this?

update table_name set field_name = replace(field_name,'find_this','replace_with_that');

[criterion9]

something like this?

update table_name set field_name = replace(field_name,'find_this','replace_with_that');

That looks about right. I would test on a sample dataset before throwing production data through it just to be safe though.

[ZABI]

something like this?

update table_name set field_name = replace(field_name,'find_this','replace_with_that');

Thanx man... thats what I wanted