and, or

The and and or operators select documents that contain the specified search elements. Each result is relevance-ranked. The and operator selects documents that contain all the elements specified in the query. For example, the following query selects documents that contain both “Iranian” and “business”:

select t2.copy
from i_blurbs t1, blurbs t2
where t1.id=t2.id 
and t1.index_any = "(Iranian <and> business)"

The or operator selects the documents that contain any of the search elements. For example, if the preceding query is rewritten to use the or operator, the query selects documents that contain the word “Iranian” or “business”:

select t2.copy
from i_blurbs t1, blurbs t2
where t1.id=t2.id 
and t1.index_any = "(Iranian <or> business)"