Complex user interests query
WITH cte AS 
(
SELECT *, 
       CASE field WHEN 'ShortName'
                  THEN CASE operator WHEN 'Contains'
                                     THEN ShortName LIKE CONCAT('%', criteria, '%')
                                     WHEN 'Equal'
                                     THEN ShortName = criteria
                                     ELSE 0
                                     END
                  WHEN 'Genre'
                  THEN CASE operator WHEN 'Is'
                                     THEN Genre = criteria
                                     WHEN 'IsNot'
                                     THEN Genre != criteria
                                     ELSE 0
                                     END
                  WHEN 'Time_Mins'
                  THEN CASE operator WHEN 'IsGreaterThan'
                                     THEN Time_Mins &gt; criteria
                                     WHEN 'IsLessThan'
                                     THEN Time_Mins &lt; criteria
                                     ELSE 0
                                     END
                  WHEN 'Action'
                  THEN CASE operator WHEN 'Is'
                                     THEN Action = criteria
                                     WHEN 'IsNot'
                                     THEN Action != criteria
                                     ELSE 0
                                     END
                  ELSE 0
                  END test
FROM movies
CROSS JOIN filters
)
SELECT MovieID, ShortName, Genre, Time_Mins, Action, filterid
FROM cte
GROUP BY MovieID, ShortName, Genre, Time_Mins, Action, filterid
HAVING SUM(test=0)=0
ORDER BY MovieID, filterid;


fiddle

Pay attention to formalized filters storing format.

You may add possible operator/criteria values by adding according variants into CASEs. 

For example, if you want to add a filtering variant for to select strict time you must add WHEN 'Equal' THEN Time_Mins = criteria to Time_Mins checking CASE. 

But do not forget that criteria datatype is STRING! And Action datatype is string too. Use proper data type convertion when default convertion is not obvious.