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/>