Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • December 4, 2011 at 6:16 pm in reply to: Data Search –> Replace #32906
    Exzo
    Member

    PHP / Perl / Ruby / Python / whatever

    Something like:

    Code:
    loop thru (“SHOW TABLES”) {

    loop thru (“SHOW COLUMNS IN $table”) {

    “UPDATE `$table` SET $field = REPLACE($field, '$srch', '$replc')”;
    }
    }

    Or even simpler – use `information_schema` .`COLUMNS`. This makes it possible to make stored procedure for SQL-only solution.

    December 3, 2011 at 6:34 pm in reply to: Data Search –> Replace #32904
    Exzo
    Member

    Just make a special script for that. The effort would pay off easily.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)