title: Cassandra: List all tables in keyspace based on restriction such as LIKE or CONTAINS?
body: <p>I have many tables per keyspace, therefore I would like to filter the tables based on restriction criteria. I tried this query but it is not really giving the intended result that I want:</p>
  
  <pre><code>SELECT table_name FROM system_schema.tables 
  WHERE keyspace_name = 'test' 
  and table_name &gt;= 'test_001_%';
  </code></pre>
  
  <p>The output shown is:</p>
  
  <pre><code>'table_name'
  ---------------------
   'test_001_metadata'    
   'test_001_time1'    
   'test_001_time2'    
   'test_001_time3'    
   'test_001_time4'    
   'test_002_metadata'    
   'test_002_time1'    
   'test_002_time2'
   'test_002_time3'
  </code></pre>
  
  <p>What I really want is: 
  The output shown is:</p>
  
  <pre><code>'table_name'
  ---------------------
   'test_001_metadata'    
   'test_001_time1'    
   'test_001_time2'    
   'test_001_time3'    
   'test_001_time4'   
  </code></pre>
  
  <p>The other way out is to use <code>LIKE</code> keyword by creating secondary index on table_name. But I am a bit skeptical if it might cause problem as it is a system table. Another concern is, does clustering column ACTUALLY support secondary index?</p>