jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gary Long <gary.l...@gmx.fr>
Subject fulltext search & sql query
Date Mon, 14 Sep 2009 14:07:48 GMT

Hi :)

I have a JCR with files converted into binary and i'm trying to perform
fulltext search. I'm using SQL. 
My query is :

"SELECT * FROM mnt:resource WHERE contains(* , '" + textQuery + " OR " +
textQuery + "% OR %" + textQuery + " OR %" + textQuery + "%')"

When i try  for the word lucene (for exemple) i get results. But if i try
with luc or lucen, there are no matches...

I don't understand why?

Could someone help me please ? :)

Thanks

Gary
-- 
View this message in context: http://www.nabble.com/fulltext-search---sql-query-tp25436447p25436447.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.


Mime
View raw message