Hey all,
Is it possible to execute a query on db that will replace all instances of a character string such as <br> that apperas in table records?

TIA

    I don't know of any way to globally change every column in every table. If you know which columns might need to be changed, you could do it by table with something like:

    UPDATE table_name SET column_name = REPLACE(column_name, '<br>', '<br />')

      NogDog. Thanks. I know the db, table, and column I wish to change. So I'm going to try your method and see if it works.

        When I run that query, it says 0 rows affected. Obviously I have replaced table_name and column_name with the correct values.

          Ah, nevermind. I typo'd. It worked, thanks!

            Write a Reply...