[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[no subject]



On 8/9/05, James Sumners <james.sumners at gmail.com> wrote:
> 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
&gt; <a  rel="nofollow" href="http://james.roomfullofmirrors.com/";>http://james.roomfullofmirrors.com/</a>
&gt; 
&gt; &quot;All governments suffer a recurring problem: Power attracts
&gt; pathological personalities. It is not that power corrupts but that it
&gt; is magnetic to the corruptible. Such people have a tendency to become
&gt; drunk on violence, a condition to which they are quickly addicted.&quot;
&gt; 
&gt; Missionaria Protectiva, Text QIV (decto)
&gt; CH:D 59
&gt; 


-- 
James Sumners
<a  rel="nofollow" href="http://james.roomfullofmirrors.com/";>http://james.roomfullofmirrors.com/</a>

&quot;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.&quot;

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


</pre>
<!--X-Body-of-Message-End-->
<!--X-MsgBody-End-->
<!--X-Follow-Ups-->
<hr>
<!--X-Follow-Ups-End-->
<!--X-References-->
<ul><li><strong>References</strong>:
<ul>
<li><strong><a name="00101" href="msg00101.html">[ale] Indexing datetime field in mysql?</a></strong>
<ul><li><em>From:</em> kboateng_cs at yahoo.com (Kofi Boateng)</li></ul></li>
<li><strong><a name="00103" href="msg00103.html">[ale] Indexing datetime field in mysql?</a></strong>
<ul><li><em>From:</em> james.sumners at gmail.com (James Sumners)</li></ul></li>
</ul></li></ul>
<!--X-References-End-->
<!--X-BotPNI-->
<ul>
<li>Prev by Date:
<strong><a href="msg00103.html">[ale] Indexing datetime field in mysql?</a></strong>
</li>
<li>Next by Date:
<strong><a href="msg00105.html">[ale] Mail System Error - Returned Mail</a></strong>
</li>
<li>Previous by thread:
<strong><a href="msg00103.html">[ale] Indexing datetime field in mysql?</a></strong>
</li>
<li>Next by thread:
<strong><a href="msg00105.html">[ale] Mail System Error - Returned Mail</a></strong>
</li>
<li>Index(es):
<ul>
<li><a href="maillist.html#00104"><strong>Date</strong></a></li>
<li><a href="threads.html#00104"><strong>Thread</strong></a></li>
</ul>
</li>
</ul>

<!--X-BotPNI-End-->
<!--X-User-Footer-->
<!--X-User-Footer-End-->
</body>
</html>