我可以在 sqlite 工具中执行此操作:
sqlite> select caption from notes_fts where notes_fts MATCH '"perl install"';
但不能从 Linux shell 即失败:
user@host:~$ sqlite3 sqldb "select caption from notes_fts where notes_fts MATCH '"it perl install "';"
我尝试了不同版本的引用"
,但没有成功。
答案1
尝试一下:
sqlite3 sqldb "select caption from notes_fts where notes_fts MATCH '\"perl install\"';"
答案2
尝试一下:
sqlite3 sqldb "select caption from notes_fts where notes_fts MATCH 'perl install';"