Israel Hanukoglu, Ph.D.
Laboratory of Cell Biology
Ariel University
Ariel 40700, Israel

Software : DB Browser for SQLite issues

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

Database filtering is not working

In SQLite Browser that comes with Linux Mint (Ubuntu) version 18.1 the Filter function of the database does not work.

Solution: I installed the most recent version of DB Browser and this solved the problem.

To add the update to the Linux repository, run the following code in a terminal:

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

After this, go to Mint Update and click the Install Updates button.

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 found string with this string');

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.