471,090 Members | 1,410 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

count(*)

D
select count(*) from syslog.SystemEvents where message like
'%postfix/smtp[%' and (message like '%@carcass.us>%' or message like
'%@deadghost.com>%' or message like '%@phatho.com>%');

Above query returns error. Have no idea how to count something like this and
the manual is not helping. I'm thinking select it into a temp table and then
count? I have had no luck with temp tables either. They just don't seem to
work for me. Anyone got a simple solution?
Jul 23 '05 #1
1 1242
D
I figured it out:

select count(distinct id) from syslog.SystemEvents where message like
'%postfix/smtp[%' and (message like '%@carcass.us>%' or message like
'%@deadghost.com>%' or message like '%@phatho.com>%');
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

22 posts views Thread by Ling Lee | last post: by
6 posts views Thread by Geetha | last post: by
5 posts views Thread by Eric Johannsen | last post: by
23 posts views Thread by Gary Wessle | last post: by
22 posts views Thread by MP | last post: by
3 posts views Thread by Auddog | last post: by
7 posts views Thread by Chris | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.