Hi Roy,
first of all I think this is rather a post for the user list
than the dev list of Jackrabbit.
On 9/2/06, Roy Russo <roy.russo@jboss.com> wrote:
> Running in to a problem when searching jcr:data types...
>
> "select * from portalcms:content where jcr:data like '%JBoss%'";
I assume that in your example you want to issue
a fulltext search looking for "JBoss", correct?
So your query should look like this:
select * from nt:resource where contains(*,'JBoss')
See page 296: 8.5.4.5 CONTAINS
of the JCR v1.0 spec
regards,
david
|