question

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?