Hey Victor,
For what it's worth, that doesn't seem to work. Is it possible I've done something wrong?
mysql> SELECT * from interfaces where ip_addr REGEXP '^128\.*';
+------+---------+-------+------------+-----------------+---------+----------+-------------+----------+----------+--------------+------------+--------------+----------------+-------------+------------+-----------------+---------------------+----------------+
| id | node_id | flags | ip_addr | ip_netmask | if_type | if_index | bridge_port | phy_slot | phy_port | peer_node_id | peer_if_id | mac_addr | required_polls | admin_state | oper_state | dot1x_pae_state | dot1x_backend_state | description |
+------+---------+-------+------------+-----------------+---------+----------+-------------+----------+----------+--------------+------------+--------------+----------------+-------------+------------+-----------------+---------------------+----------------+
| 142 | 124 | 4 | 128.0.0.1 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0001 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 739 | 124 | 4 | 128.0.0.32 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0001 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 919 | 813 | 12 | 128.0.0.1 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
| 920 | 813 | 12 | 128.0.1.16 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
| 950 | 124 | 4 | 128.0.0.17 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0001 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 987 | 972 | 4 | 128.0.0.1 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0000 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 1092 | 972 | 4 | 128.0.0.16 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0000 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 1093 | 972 | 4 | 128.0.0.32 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0000 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 2398 | 2349 | 12 | 128.0.0.1 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
| 2399 | 2349 | 12 | 128.0.0.4 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
| 2400 | 2349 | 4 | 128.0.0.6 | 255.255.255.255 | 53 | 526 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | sp-0/0/0.16383 |
| 2401 | 2349 | 12 | 128.0.1.16 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
| 2709 | 2694 | 4 | 128.0.0.1 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0005 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 3169 | 2694 | 4 | 128.0.0.21 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0005 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 3170 | 2694 | 4 | 128.0.0.32 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0005 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 5775 | 5729 | 12 | 128.0.0.1 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
| 5776 | 5729 | 12 | 128.0.0.4 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
| 5777 | 5729 | 4 | 128.0.0.6 | 255.255.255.255 | 53 | 532 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | sp-0/0/0.16383 |
| 5778 | 5729 | 12 | 128.0.1.16 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
+------+---------+-------+------------+-----------------+---------+----------+-------------+----------+----------+--------------+------------+--------------+----------------+-------------+------------+-----------------+---------------------+----------------+
For what it's worth, that doesn't seem to work. Is it possible I've done something wrong?
mysql> SELECT * from interfaces where ip_addr REGEXP '^128\.*';
+------+---------+-------+------------+-----------------+---------+----------+-------------+----------+----------+--------------+------------+--------------+----------------+-------------+------------+-----------------+---------------------+----------------+
| id | node_id | flags | ip_addr | ip_netmask | if_type | if_index | bridge_port | phy_slot | phy_port | peer_node_id | peer_if_id | mac_addr | required_polls | admin_state | oper_state | dot1x_pae_state | dot1x_backend_state | description |
+------+---------+-------+------------+-----------------+---------+----------+-------------+----------+----------+--------------+------------+--------------+----------------+-------------+------------+-----------------+---------------------+----------------+
| 142 | 124 | 4 | 128.0.0.1 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0001 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 739 | 124 | 4 | 128.0.0.32 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0001 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 919 | 813 | 12 | 128.0.0.1 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
| 920 | 813 | 12 | 128.0.1.16 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
| 950 | 124 | 4 | 128.0.0.17 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0001 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 987 | 972 | 4 | 128.0.0.1 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0000 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 1092 | 972 | 4 | 128.0.0.16 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0000 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 1093 | 972 | 4 | 128.0.0.32 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0000 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 2398 | 2349 | 12 | 128.0.0.1 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
| 2399 | 2349 | 12 | 128.0.0.4 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
| 2400 | 2349 | 4 | 128.0.0.6 | 255.255.255.255 | 53 | 526 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | sp-0/0/0.16383 |
| 2401 | 2349 | 12 | 128.0.1.16 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
| 2709 | 2694 | 4 | 128.0.0.1 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0005 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 3169 | 2694 | 4 | 128.0.0.21 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0005 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 3170 | 2694 | 4 | 128.0.0.32 | 192.0.0.0 | 53 | 38 | 0 | 0 | 0 | 0 | 0 | 000BCAFE0005 | 0 | 1 | 1 | 0 | 0 | bme0.32768 |
| 5775 | 5729 | 12 | 128.0.0.1 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
| 5776 | 5729 | 12 | 128.0.0.4 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
| 5777 | 5729 | 4 | 128.0.0.6 | 255.255.255.255 | 53 | 532 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | sp-0/0/0.16383 |
| 5778 | 5729 | 12 | 128.0.1.16 | 255.255.255.255 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 000000000000 | 0 | 1 | 1 | 0 | 0 | lo0.16385 |
+------+---------+-------+------------+-----------------+---------+----------+-------------+----------+----------+--------------+------------+--------------+----------------+-------------+------------+-----------------+---------------------+----------------+