Tagged Questions
0
votes
2answers
110 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
177 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 ...
