SubString in query CQL

Question

It is possible to found a substring in a String in CQL ? For exemple, make a query like this :

select id from table where string contains 'do' Thank you in advance

Answer 1

Yes, this is possible with the usage of Storage Attached Index (SASI). Your query will be something like:

SELECT * FROM table WHERE colname LIKE 'do%';

Have a look at official documentation on how to use it.