Monday, January 9, 2023

Correct spelling mistakes in SQLite

 I have used the following method to check for and fix misspelled words in a SQLite database.

Note: This was for a database with less than 500 records 

1) Load the database into DB Browser (SQLite)
2) Select the columns you want to perform the spellcheck on and copy
3) Paste into a blank spreadsheet
4) Do a spellcheck in the spreadsheet
5) Make a note of the records with misspelled words.
6) Correct those records in DB Browser

No comments:

Post a Comment