0
votes
2answers
150 views

sqlite fts quoting problem

I can do this in sqlite tool: sqlite> select caption from notes_fts where notes_fts MATCH '"perl install"'; but cannot from the Linux shell i.e., this fails: user@host:~$ sqlite3 sqldb ...
1
vote
2answers
326 views

sqlite3 bash grep username

#!/bin/bash username=$(sqlite3 db.sl3 "select user from main";) yad --list --column="#" "$username" --height 200 I want to display the usernames of my db in a list and then select one of theme. The ...