search and replace using a sql statement

[n8w]

I have a column that has values like

 

record 1 = bob,nancy, sally

record 2 = bob,nancy

record 3 = nancy, sally

 

What I would like to do is replace all instances of nancy with betty so all my records would look like this

 

record 1 = bob,betty, sally

record 2 = bob,betty

record 3 = betty, sally

 

can someone please point me in the right direction of what my sql statement should look like?

 

Thanks

[awjudd]

You can use MySQL's REPLACE function

 

http://dev.mysql.com/doc/refman/5.0/en/replace.html

 

Either do it in a SELECT statement (non-permanent) or an UPDATE statement (changing the actual values in the table).

 

~awjudd

[n8w]

Thanks .. this worked great

 

update client_table set company_name = replace(company_name, ‘Old Company’, ‘New Company’)