rendered paste body| 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