Hi Guys,
We have a table that has a number of fields (category, type, format,
etc.) all of which are integers and we have a text field that we need to
search for. So, what we want to do is a query like:
select * from myTable where text_field = '...' and category = 2;
Currently, to support this, we have indexes such as
category, text_field
type, text_field,
etc.
Since we're searching text, it should be possible (and possibly faster?)
to use FTS. But I couldn't figure out how we could do a simple '='
query using FTS.
I tried:
- fts_table.fts_column match "A" # returns items like 'A', 'A ZIU' as
well as 'ZI A' (we wanted only 'A')
- using fts_table.fts_column match "^A" (is this allowed?) seems to
return items such 'A', 'A ZIU' but not 'ZI A'
What do you recommend we use?
Thanks,
Mohit.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
