Remove or Replace with blank partial string in MySQL Query
I'm trying to replace only certain parts of a string via an SQL query.

The column holds data formatted as so:

    United States Postal Service&nbsp;<br> (Express Mail<sup>&reg;</sup><br>---Approx. delivery time 07-Sep-2011):

I'm trying to make it export like so:

    United States Postal Service (Express Mail---Approx. delivery time 07-Sep-2011):

To do this, I used CASE, like so:

    SELECT 
    	CASE ot.title
    		WHEN 'Free' THEN ''
    		WHEN '&nbsp;<br>' THEN ' '
    		WHEN '<sup>&reg;</sup> ' THEN ' '
    		WHEN '<br>---' THEN '---'
    		ELSE ot.title
    	END
    FROM orders_total AS ot;

However, it won't work.  I assume CASE only supports handling the entire string, not just a part of it.

Any ideas?

Peace,
Chris
Remove or Replace with blank partial string in MySQL Query
===

I'm trying to replace only certain parts of a string via an SQL query.

The column holds data formatted as so:

    United States Postal Service&nbsp;<br> (Express Mail<sup>&reg;</sup><br>---Approx. delivery time 07-Sep-2011):

I'm trying to make it export like so:

    United States Postal Service (Express Mail---Approx. delivery time 07-Sep-2011):

To do this, I used CASE, like so:

    SELECT 
    	CASE ot.title
    		WHEN 'Free' THEN ''
    		WHEN '&nbsp;<br>' THEN ' '
    		WHEN '<sup>&reg;</sup> ' THEN ' '
    		WHEN '<br>---' THEN '---'
    		ELSE ot.title
    	END
    FROM orders_total AS ot;

However, it won't work.  I assume CASE only supports handling the entire string, not just a part of it.

Any ideas?

Peace,
Chris