Fulltext search

[jgrar]

Should we use fulltext matching for searches?

[mischief]

as opposed to what? regexp?
right now we're just using whatever sqlite's LIKE %query% does

[jgrar]

http://www.sqlite.org/fts3.html

In SQL full-text matches break input words into seperate terms.