[ale] Indexing datetime field in mysql?

[James Sumners]

SELECT st_time, INET_NTOA(src_ip) as source, INET_NTOA(dst_ip) as dest
FROM ff.flow WHERE st_time BETWEEN > '2005-07-01 23:55:55' and
'2005-08-08 00:00:00' AND proto = '6' ORDER BY source ASC;

You might also want to specify the table that it should be pulling
st_time from; something like "source.st_time".

-- 
James Sumners
http://james.roomfullofmirrors.com/

"All governments suffer a recurring problem: Power attracts
pathological personalities. It is not that power corrupts but that it
is magnetic to the corruptible. Such people have a tendency to become
drunk on violence, a condition to which they are quickly addicted."

Missionaria Protectiva, Text QIV (decto)
CH:D 59