Can you mass replace characters with mySql?

[HowdeeDoodee]

I want to mass replace three htlm character sets in one field in all records in my db. The field name is Subtopic and the db name is ViewTest. I want to replace <br><br><br> with <br><br> in all records. Is there a way to to this?

 

[HowdeeDoodee]

OK, folks here is your answer or my answer or however you want to put it.

Syntax:
update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

Sytax applied to my particular table and so forth.

SQL-query: 
UPDATE `ViewTest` SET `Subtopic` = REPLACE ( `Subtopic` ,
'<br><br><br>',
'<br><br>')