My table is set up like so:
Code: Select all
+--------------+
| ip |
+--------------+
| XXX.185.3.1 |
| XXX.185.3.31 |
| XXX.185.3.32 |
+--------------+I haven't really gotten too far with this, as I'm not even sure where to begin. I'm thinking using an IF statement or a sub-query might be helpful, but I'm kind of lost. I'm using MySQL 5.0.18.
Thanks for any and all insight.