Israel Hanukoglu, Ph.D.

Software : DB Browser for SQLite issues

DB Browser for SQLite is the new name for SQLite Browser.

Install the latest stable version in Linux Mint

sudo add-apt-repository ppa:linuxgndu/sqlitebrowser
sudo apt-get update
sudo apt-get install sqlitebrowser

Replace text in multiple records in a database

Enter the following text in the window that opens when you click the Execute SQL tab.

update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, 'find this string', 'replace it with this');

And then, CLICK the "Execute SQL" button that is shaped like a blue triangle.

If the command is executed you will see a "Query executed successfully" message at the bottom window.