Using ANY operator in RLS policy

Hi, new to Supabase and SQL so apologies but I'm stuck when trying to implement this policy on the

missions

missions

missions

missions table. Summarized Allow if

user.authorized_missions

user.authorized_missions

user.authorized_missions

user.authorized_missions (Array) contains

missions.id

missions.id

missions.id

missions.id

Here is my current policy:

any (user.authorized_missions) = missions.id

any (user.authorized_missions) = missions.id

any (user.authorized_missions) = missions.id

any (user.authorized_missions) = missions.id
but throwing "syntax error at or near 'any'". How can I fix this?