I'm experimenting with the FTS capability and have a question.... How do I enter a value in the database that is hyphenated? Seems to be backwards form what I would expect....if the content contains a hyphen then only non-hyphenated query returns the correct value whereas the hyphenated one returns the wrong one. This seems to not work correctly...or am I missing a concept here? SQLite version 3.7.2 sqlite> create virtual table dict using fts3(content); sqlite> insert into dict values('play-off'); sqlite> insert into dict values('play-back'); sqlite> select * from dict where content match 'play-back'; play-off sqlite> select * from dict where content match 'play-off'; play-back sqlite> select * from dict where content match 'play off'; play-off sqlite> select * from dict where content match 'play back'; play-back Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users