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?