Replace values 1

[buzzt]

How would I replace all instances of something like this in all entries in a column?

[blue]aaa - bbb - ccc[/blue] to [blue]aaa, bbb, ccc[/blue]

Change any instance of " - " to ", " in all entries in the column (even though the entries are all different, I want to change only this part of them).

 

[sleipnir214]

Something like:

UPDATE tablename SET columnname = replace(columname, '-', ',')



Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[buzzt]

Will this not replace all the text in each entry field? I don't want to change anything else.

 

[sleipnir214]

According to

http://www.mysql.com/doc/en/String_functions.html:

REPLACE(str,from_str,to_str)
Returns the string str with all occurrences of the string from_str replaced by the string to_str:
[ignore]
mysql> SELECT REPLACE('

http://www.mysql.com',

'w', 'Ww');
-> '

http://WwWwWw.mysql.com'

[/ignore]

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[buzzt]

It seems to have worked (I hope without problems later). Thanks very much for the help.