mysql> SELECT host_id, hostname, rrd_name, arg1 FROM poller_item WHERE hostname = '192.168.2.2' AND rrd_name LIKE 'Sensor%'; +---------+-------------+-----------------+------+ | host_id | hostname | rrd_name | arg1 | +---------+-------------+-----------------+------+ | 1 | 192.168.2.2 | Sensor_MB_Temp | | | 1 | 192.168.2.2 | Sensor_CPU_Temp | | +---------+-------------+-----------------+------+ 2 rows in set (0.00 sec)