How to query row containing the given element inside a JSON column in Laravel PostgreSQL
Select id, a from (SELECT Id,
  json_array_elements(r.agents) A
   FROM Cnms_rosters r) ra 
   Where A::TEXT = '13';


See http://sqlfiddle.com/#!17/eb400/19