Re: [sqlite] Does SQLite have a fulltext search like MySQL?

[Jim Dodgen]

look at the glob command it works like like except uses the unix file name 
globbing style of matching
not quite a grep

select * from table where a glob '[abc]foobar*';
At 06:47 PM 7/5/2005, you wrote:
like this?
select * from table where a like '%abc%';

SQLite also makes it easy to write your own functions.  That way you
can define other matching algorithms (eg Jaro-Winkler).

Roger