I think Sylvain may not have had his coffee yet.  You can't use IF's in
SELECT statements, but you can in INSERT/UPDATE/DELETE:

UPDATE foo SET a = 0 WHERE k = 0 IF b != 0;

On Tue, Sep 30, 2014 at 2:36 AM, Sylvain Lebresne <sylv...@datastax.com>
wrote:

>
>
>> Is != supported as part of the where clause in Cassandra?
>>
>
> It's not.
>
> Or is it the grammar for some other purpose?
>>
>
> It's supported in 'IF' conditions. You can do something like:
>   SELECT * FROM foo WHERE k = 0 IF v != 3;
>
> --
> Sylvain
>



-- 
Tyler Hobbs
DataStax <http://datastax.com/>

Reply via email to