I wrote:
UPDATE `table_name` SET column_name = REPLACE(column_name, - , <br />) WHERE column_name LIKE '% - %'
I tried to escape < and > with an \ but I get error messages... What's wrong?
Thanks for any help.
Problem solved...
UPDATE `table_name` SET column_name = REPLACE(column_name, ' - ', '<br />') WHERE column_name LIKE '% - %'