jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gary Long <l...@magillem.com>
Subject How to handle the colon character within fulltext search?
Date Fri, 25 Jun 2010 09:42:02 GMT
Hello there :)

I'm using the fulltext search feature of Jackrabbit and i'm facing a 
little problem with the colon character (:). For example, if I search 
for a mail which subject is "Tr : Tr : your response", I can't find it. 
If I search for "your response" the e-mail is found.

my sql query is :

SELECT * FROM mnt:resource WHERE (contains(jcr:text, '*tr: tr: your 
response*') OR contains(jcr:name, '*tr: tr: your response*');

Thank you for your help :)

Gary Long

View raw message