MySQL Forums
Forum List  »  Stored Procedures

Matching entries
Posted by: jennifer berube
Date: August 28, 2007 11:47AM

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` ()
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

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...

Options: ReplyQuote

Written By
Matching entries
August 28, 2007 11:47AM
August 29, 2007 07:24AM
August 29, 2007 11:49AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.