jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gadbury <gadb...@googlemail.com>
Subject SQL2 - multiple where conditions
Date Thu, 04 Mar 2010 15:31:01 GMT

Hi,

I understand that in MySQL I can perform the following multiple where clause
select.

SELECT * FROM Table WHERE id IN (0,2,3);

Is there an equivelent in Jackrabbit 2.0 using the query language JCR_SQL2?

I know the following works (but is there a better way?) :

SELECT * FROM [my:table] WHERE [id]=0 OR[id]=2 OR [id]=3

Thanks and kind regards,

James
-- 
View this message in context: http://n4.nabble.com/SQL2-multiple-where-conditions-tp1578233p1578233.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Mime
View raw message