On 12/15/08, aditya siram <[email protected]> wrote:
> Hi all,
> I am trying to implement an autocompleter with a sqlite backend. Is there a
> way to search the database using wildcards/regexps's without reading the
> entire search space into memory?
>
> For example given the rows:
> 'hello world'
> 'goodbye world'
> a query approximately like "* world" should return both.
>
and so it does...
sqlite> CREATE TABLE foo (a);
sqlite> INSERT INTO foo VALUES ('hello world');
sqlite> INSERT INTO foo VALUES ('goodbye world');
sqlite> SELECT * FROM foo WHERE a LIKE '%world';
hello world
goodbye world
sqlite> SELECT * FROM foo WHERE a GLOB '*world';
hello world
goodbye world
sqlite>
Read the docs on the difference between LIKE and GLOB
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
