MySQL Forums
Forum List  »  Newbie

Re: Select Statement Output
Posted by: carlo s
Date: December 15, 2009 08:44PM

I was able to get just the External IP to be displayed:

select substring(MsgText,POSITION('outside' IN MsgText)+8, POSITION('(' IN MsgText)-73) as outside from Syslogd;

It would be nice to show:
External IP | Dest Port | Date | Sum Total Hit Count

Any idea's out there?

Options: ReplyQuote


Subject
Written By
Posted
December 14, 2009 02:58PM
Re: Select Statement Output
December 15, 2009 08:44PM
January 02, 2010 07:36PM


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.