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

Options: ReplyQuote


Subject
Views
Written By
Posted
Matching entries
2699
August 28, 2007 11:47AM
1062
August 29, 2007 07:24AM
1067
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.