Take the 2-minute tour ×
Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems.. It's 100% free, no registration required.

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  "select caption  from notes_fts where notes_fts MATCH '"it perl install  "';"

I tried different versions of quoting " but it didn't work.

share|improve this question
add comment

2 Answers

Try that :

sqlite3 sqldb "select caption from notes_fts where notes_fts MATCH 'perl install';"
share|improve this answer
    
Thanks, but it didn't work as it does not have the exact matching restriction of the additional quotes i.e. if it works, the result should be an exact match e.g. UNIX My Install Your solution results in multiple inexact matches e.g. .cshrc Admin UNIX My Install 1 Liners cpan –  fsnow55 Oct 16 '12 at 14:48
add comment

Try that:

sqlite3 sqldb "select caption from notes_fts where notes_fts MATCH '\"perl install\"';"
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.