You may want to read up on Mysql :-)
delete from logs where host like '%192.168.1.1%';
or use regex to find multiple IP's
On Jan 28, 2008 2:21 PM, <[EMAIL PROTECTED]> wrote:
> Sure, what is sql statement to use ;-)
>
> Thanks!
>
> .vp
>
> ------------------------------
> Date: Mon, 28 Jan 2008 14:03:59 -0500
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> CC: [email protected]
> Subject: Re: [Php-syslog-ng-support] Refreshing Host Seelction In "Search"
>
>
> Delete them from the database?
>
>
> On Jan 22, 2008 1:08 PM, <[EMAIL PROTECTED]> wrote:
>
> Hello;
>
> I am trying to determine the best way to remove from my "HOSTS" selection
> those hosts which are no longer contained in any of the logs, most recent or
> others in DB. My list is quickly growing and while I had a DNS issue two
> weeks ago, that problem has been resolved and I am now able to capture logs
> with hostnames versus the IP addresses they once had. The problem is that I
> no longer wish to retain both the IP addresses as well as the "test" content
> data.
>
> Thanks again,
>
> .vp
>
> --~--~---------~--~----~------------~-------~--~----~
> You received this message because you are subscribed to the Google Groups
> "php-syslog-ng user support forum" group.
> To post to this group, send email to
> [EMAIL PROTECTED]
> To unsubscribe from this group, send email to
> [EMAIL PROTECTED]
> For more options, visit this group at
> http://groups.google.com/group/php-syslog-ng-support?hl=en
> -~----------~----~----~----~------~----~------~--~---
>
>
>
>
> --
> ______________________________________________________________
>
> Clayton Dukes
> ______________________________________________________________
>
>
--
______________________________________________________________
Clayton Dukes
______________________________________________________________
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Php-syslog-ng-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
