Re: LIKE

2017-06-23 Thread Jeff Jirsa
On 2017-06-20 23:44 (-0700), web master wrote: > I have this table > > CREATE TABLE users_by_username ( > username text PRIMARY KEY, > email text, > age int > ) > > I want to run query like the following > > select username from users where username LIKE 'shl%' LIMIT 10; > > >

Re: LIKE

2017-06-21 Thread @Nandan@
If you are sure , that you want to do LIKE , then you can go with SASI . https://docs.datastax.com/en/dse/5.1/cql/cql/cql_using/useSASIIndex.html Hope this will help you . On Wed, Jun 21, 2017 at 2:44 PM, web master wrote: > I have this table > > CREATE TABLE users_by_username ( > username