Code: Select all
SELECT id,noteName,noteData from noteTable WHERE noteData LIKE "%hibiscus%"
If I open the db in the MacOS app "DB Browser for SQLite", the query runs just fine.
Also, my queries *used* to run just fine in my stack. Suddenly today I'm getting the error. I can't think of anything that changed.
Typing "sqlite3" into Terminal, I get "SQLite version 3.34.0 2020-12-01 16:14:00".
Running MacOS 10.13.6, LC Community Edition 9.6.2-rc2.