Working with database tables can be easy and convenient if you have the DB Replacer component. This extension for Joomla sites allows you to quickly search and replace data in any table.

Demo: https://regularlabs.com/dbreplacer/features