Matching entries

[jennifer berube]

I have this stored procedure which breaks a column up so that it separates the IP address into the "IP ADDRESS" column.

CREATE PROCEDURE `webstatus`.`test` ()
BEGIN
select substring_index(message,' ',2) as up_or_down
, substring_index(message,' ',-1) as IP_Address, `ID`, `date`, `time`, `type`, `source`, `warning`, `alarms`

from alarms
;
END

But I'd like to continue this stored procedure with something a little more complicated:

I'd like to have it match up the IP addresses in the IP ADDRESS column. If there is a match then it should be removed from the table. If there isn't a match then it should remain in the table. What do ya'll think? Bear with me...I'm new to stored procedures...