sqlite fts quoting problem

Question

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.

CL. · Accepted Answer · 2012-10-18 20:40:44Z

1

Try that:

sqlite3 sqldb "select caption from notes_fts where notes_fts MATCH '\"perl install\"';"

answered Oct 18, 2012 at 20:40

CL.

2,65415 silver badges15 bronze badges

Add a comment |

Gilles Quénot · Accepted Answer · 2012-10-15 23:26:14Z

0

Try that :

sqlite3 sqldb "select caption from notes_fts where notes_fts MATCH 'perl install';"

answered Oct 15, 2012 at 23:26

Gilles Quénot

32.1k7 gold badges64 silver badges82 bronze badges

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, 2012 at 14:48

Add a comment |

2 Answers 2