How to use PhpMyAdmin to do a find & replace in your database

Run this query to find A and replace with B:

  1. UPDATE `tablename` SET `fieldname` = REPLACE(title,'A','B')
  2. //optional when you search in a Drupal database.
  3. WHERE `type` = 'fieldtype' AND `fieldname` LIKE '%A%'

Tips: You can use "WHERE" to limit your search.

Article Information
Article ID Categories Tags Levels Status