title: How is it possible to do wildcard search on apache cassandra at the beginning of the string like '%string' as we do in Sql?
body: <p>i need to do wildcard search  like this on apache cassandra, SELECT * FROM <em>table_name</em> where <em>col_name</em> like "string%";</p>
  
  <p>I know there is no wildcard support like this in Cassandra. I have to maintain some indices for this purpose. I have read through these links which were very much helpful.<br/>
  <a href="https://stackoverflow.com/questions/20602466/cassandra-cql-3-prefix-select">Cassandra CQL 3 - Prefix Select</a><br/>
  <a href="https://stackoverflow.com/questions/3138738/is-there-any-trick-to-do-wildcards-search-on-apache-cassandra">is there any trick to do wildcards search on apache cassandra?</a><br/></p>
  
  <p>I could design data model which allows wild cards at the end of the string and where I can get result like --><br/>
  SELECT * FROM <em>table_name</em> where <em>col_name</em> like 'str%'; by maintaning an index and with normal range queries from str:sts. But I want wild cards at the beginning of the string like '%str'. <br/>
  Is there any possible way to do this? Any help will be appreciated.<br/><br/>
  Thanks in advance.</p>