Actually this query might be more correct....the other would match any
t/online.de combination -- so we restrict to NEAR/0 separation...
select * from contacts where contacts match replace('t-online.de','-',' NEAR/0
');
m...@t-online.de
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
________________________________
From: sqlite-users-boun...@sqlite.org on behalf of ady
Sent: Tue 11/23/2010 7:53 AM
To: sqlite-users@sqlite.org
Subject: EXTERNAL:[sqlite] FTS Question
Hello!
I am trying this query
select * from contacts where contacts match ('*t-online.de*')
How could i modify this query to return say m...@t-online.de ?
the - is an exclusion
Thanks in advance!
Ady
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
