I went through this before.
How's this look to you?
Just replace the dashes with spaces and it works.
select * from contacts where contacts match (replace('%t-online.de%','-',' '));
The problem is that the default tokenizer splits the address anyways at the
hyphen and there's no way to turn off the hyphen behavior for NOT.
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
