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
');
[email protected]
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
________________________________
From: [email protected] on behalf of ady
Sent: Tue 11/23/2010 7:53 AM
To: [email protected]
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 [email protected] ?
the - is an exclusion
Thanks in advance!
Ady
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
