DBSR: Database Search and Replace

Database connection information

Enter the connection details for the database server below.

Search and replace options

You have selected the database "DATABASE NAME" on DATABASE HOST:PORT. The connection will use the DATABASE CHARSET character set.

Please enter the search and replaces values in the form below.

When searching for a specific string it's sometimes useful to enter escaped sequences such as "\n" or \x5C".
Checking the box below will make the script interpret all escaped sequences as PHP would in a double-quoted string.
Interpret PHP escaped sequences.

Case-insensitive search is disabled by default since most databases and filesystems are case-sensitive.
Toggeling this settings might come in handy when running search-and-replace actions for user input.
Case-insensitive search.

For performance reasons, the script normally only processes rows which contain one or more of the plain search strings.
Checking the box below will make the script process every row in the entire database.
This may be useful when due to serialization the exact search strings do not occour in the database or if using this script to repair currupted serialized strings.
Run a extended search.

Confirmation

You selected the database "DATABASE NAME" on DATABASE HOST:PORT. The connection will use the DATABASE CHARSET character set.

The following strings will be used for search-and-replace:

Always make a backup of your database before using this script!
If you haven't done so yet, do it now! Remember Murphy's law!

This data is correct.

Results

RESULT occurence(s) found and replaced.

Delete this script from the server.