Check if value exists in postgres text column I have a direct_selector column

        direct_selector                
----------------------------------------------
 a:2:{i:0;s:7:"transit";i:1;s:9:"departure";}
 a:1:{i:0;s:9:"departure";}
 a:1:{i:0;s:7:"arrival";}


select * 
from disc_agent 
where direct_selector = ANY('{"departure"}');


This query gives me nothing
When I try

select * 
from disc_agent 
where '"departure"' = ANY(direct_selector);


It gives me an error 


  ERROR: op ANY/ALL (array) requires array on right side


So what I should do to check if value exists?
That is not an "array column". The contents of a real array (or even JSON) would be displayed in a different way. I guess that's just defined as text or varchar.

It's not a valid syntax for an array so you can't use any of Postgres' array functions and it's not valid JSON either so you can't use any of Postgres JSON functions. As this is plain text, the only thing you can use is LIKE or regex comparisons.

Something like:

where direct_selector LIKE '%"departure"%'; 
-- or
WHERE direct_selector LIKE '%"departure"%' AND direct_selector LIKE '%"transit"%'