Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE videos(title TEXT, categories TEXT[], views INT)
INSERT INTO videos(title, categories, views) VALUES('Movie A', ARRAY['action', 'crime'], 30)
1 rows affected

INSERT INTO videos(title, categories, views) VALUES('Movie B', ARRAY['thriller', 'crime'], 30)
1 rows affected

SELECT  v."title"
FROM public.videos v
WHERE array_to_string(v.categories, '^') ILIKE ALL (ARRAY['%thriller%', '%crime%'])
ORDER BY views DESC 
LIMIT 12 OFFSET 0


title


Movie B


 SELECT 
    "title"
  FROM 
   public.videos
  WHERE 
      EXISTS (SELECT 
                * 
              FROM (
                    SELECT 
                      COUNT(DISTINCT CASE WHEN LOWER(param) LIKE '%thriller%' THEN '0'
                                          WHEN LOWER(param) LIKE '%crime%' THEN '1' END) AS count
                    FROM
                      UNNEST(public.videos.categories) AS param
                    ) alias
                        WHERE count = 2)

  ORDER BY views DESC 

  LIMIT 12 OFFSET 0


title


Movie B