Hello dear SQLite users, Hello dr. Hipp, I'm reposting this because I didn't actually got an answer, just oppinions, which are fine as long as they are constructive...
The question is this: since most of RDBMS implement full text search, shouldn't this be a feature sqlite could support ? Brad wrote: > My regex patch should do that > SELECT * FROM Categories WHERE CategoryDescription RLIKE 'Beverages" and > CategoryDescription NOT RLIKE 'Whiskey'; > You can find a working test version here > http://www.wasp.net.au/~brad/sqlite-110104-snapshot-bkc1.tgzCould I have a 'Windows' > version?I would like to test your regex, however I need to now if what you're doing > is a full scan of the column...D. Morel wrote: > Regarding Full Text Search syntax, I think CONTAINS statement would be ok > (as implemented in other database engines). > So: > SELECT * FROM Categories > WHERE CONTAINS(CategoryDescription, 'Beverages') > would return all the rows where column CategoryDescription contains the > word 'Beverages' :-) >> doesn't SELECT * FROM Categories WHERE CategoryDescription LIKE '%Beverages%'; >> do just that ? It will, but it won't be a true 'Full Text Search', since the LIKE operator will not benefit from indexes, so a full column scan will be necessary to perform such a query. I'm quite familiar with the anayomy of a full text search engine (parsers / tokenizers / stop words etc.), but since this was a suggestion from Dr. Hipp, I was really wondering what did he have in mind: just a 'smarter' LIKE operator (which returns ranking), or something more... Best regards, George Ionescu
