Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9C6373A0B for ; Mon, 2 May 2011 10:10:34 +0000 (UTC) Received: (qmail 58704 invoked by uid 500); 2 May 2011 10:10:32 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 58669 invoked by uid 500); 2 May 2011 10:10:32 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 58661 invoked by uid 99); 2 May 2011 10:10:32 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 May 2011 10:10:32 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [74.125.82.172] (HELO mail-wy0-f172.google.com) (74.125.82.172) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 May 2011 10:10:27 +0000 Received: by wyb29 with SMTP id 29so4733455wyb.31 for ; Mon, 02 May 2011 03:10:05 -0700 (PDT) MIME-Version: 1.0 Received: by 10.216.54.134 with SMTP id i6mr7616960wec.75.1304331005056; Mon, 02 May 2011 03:10:05 -0700 (PDT) Received: by 10.216.2.208 with HTTP; Mon, 2 May 2011 03:10:04 -0700 (PDT) In-Reply-To: References: Date: Mon, 2 May 2011 12:10:04 +0200 Message-ID: Subject: Re: CQL where clause and "OR" From: Miguel Auso To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=00504502e2a739d88404a2483a45 --00504502e2a739d88404a2483a45 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable hi!, It`s posible for exemple: select * from aw_advancednewsletter_subscriptions where id=3D'1' OR id=3D'3= '; Un Saludo Miguel =C1ngel Aus=F3 2011/5/2 S=E9bastien Druon > Hi! > > Is it possible to use an "OR" operator in the "WHERE" clause of a "SELECT= " > statement? I do not find any documentation on that > > i.e. > SELECT name1 FROM cf1 WHERE name1=3Dvalue1 OR name1=3Dvalue2 > > Thanks a lot in advance > > S=E9bastien Druon > --00504502e2a739d88404a2483a45 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable hi!,

It`s posible

for exemple:<= /div>

select * from aw_advancednewsletter_subscriptions = where id=3D'1' OR id=3D'3';

Un Saludo

Miguel =C1ngel Aus=F3

2011/5/2 S=E9bastien Druon <sdruon@spotuse.com>

Hi!

Is it possible to use an "OR" operator in = the "WHERE" clause of a "SELECT" statement? I do not fi= nd any documentation on that

i.e.
SELECT= name1 FROM cf1 WHERE name1=3Dvalue1 OR name1=3Dvalue2

Thanks a lot in advance

S=E9bastien Druon

--00504502e2a739d88404a2483a45--