Hi,
I have created table using below SQL: I want to run query to find all video by actor name (case insensitive)
CREATE TABLE video_by_actor(
actor text,
added_date timestamp,
video_id timeuuid ,
character_name text,
description text ,
encoding frozen<video_encoding>,
tags set<text>,
title text,
user_id uuid,
primary key ((actor), added_date)
) with clustering order by (added_date desc);
select * from video_by_actor where actor='Tom Hanks'
// I want to search all case eg. tom hanks, Tom hanks, tom Hanks etc.
Is it possible?
