| ip            | portid |
+---------------+--------+
| 192.168.1.27 | 53     | 
| 192.168.1.27 | 80     | 
| 192.168.1.27 | 88     | 
| 192.168.1.27 | 135    | 
| 192.168.1.27 | 139    | 
| 192.168.1.27 | 389    | 
| 192.168.1.27 | 443    | 
| 192.168.1.27 | 445    | 
| 192.168.1.27 | 464    | 
| 192.168.1.27 | 593    | 
| 192.168.1.27 | 636    | 
| 192.168.1.27 | 1026   | 
| 192.168.1.27 | 1027   | 
| 192.168.1.27 | 1042   | 
| 192.168.1.27 | 1052   | 
| 192.168.1.27 | 1581   | 
| 192.168.1.27 | 2030   | 
| 192.168.1.27 | 3268   | 
| 192.168.1.27 | 3269   | 
| 192.168.1.27 | 3389   | 
| 192.168.1.27 | 3470   | 
| 192.168.1.27 | 3857   | 
| 192.168.1.27 | 8999   | 
| 192.168.1.27 | 12173  | 
| 192.168.1.27 | 12174  | 
| 192.168.1.27 | 12175  | 
| 192.168.1.27 | 12176  | 
| 192.168.1.27 | 12177  | 
| 192.168.1.27 | 12178  | 
| 192.168.1.27 | 12179  | 
| 192.168.1.27 | 12180  | 
| 192.168.1.27 | 12181  | 
| 192.168.1.27 | 12182  | 
| 192.168.1.27 | 12183  | 
| 192.168.1.28 | 22     | 
| 192.168.1.28 | 111    | 
| 192.168.1.28 | 601    | 
| 192.168.1.28 | 9000   | 
| 192.168.1.28 | 9980   | 
| 192.168.1.28 | 9999   | 
| 192.168.1.28 | 15999  | 
| 192.168.1.28 | 16000  | 
+---------------+--------+
42 rows in set (0.00 sec)

what I'd like is something like  if the port I'm looking for is 111, the results for this set would be 

192.168.1.27   FALSE
192.168.1.28   TRUE