LIKE condition allows us to use wildcards in the where clause of an SQL statement. This allows us to perform pattern matching. The
LIKE condition can be used in any valid SQL statement – select, insert, update, or delete. Like this
SELECT * FROM users WHERE user_name like 'babu%';
like the same above operation any query is available for Cassandra in CLI.