On Thu, Jan 13, 2005 at 07:14:10PM +0800, Hasnul Fadhly bin Hasan wrote:
> Hi Richard,
>
> Thanks for the reply.. is that the case? i thought it would comply to
> the where condition first..
> and after that it will format the output to what we want..
That is in fact exactly what it's doing. The
Hi Richard,
Thanks for the reply.. is that the case? i thought it would comply to
the where condition first..
and after that it will format the output to what we want..
Hasnul
Richard Huxton wrote:
Hasnul Fadhly bin Hasan wrote:
Hi,
just want to share with all of you a wierd thing that i found wh
Hasnul Fadhly bin Hasan wrote:
Hi,
just want to share with all of you a wierd thing that i found when i
tested it.
i was doing a query that will call a function long2ip to convert bigint
to ips.
so the query looks something like this.
select id, long2ip(srcip), long2ip(dstip) from sometable
whe
Hi,
just want to share with all of you a wierd thing that i found when i
tested it.
i was doing a query that will call a function long2ip to convert bigint
to ips.
so the query looks something like this.
select id, long2ip(srcip), long2ip(dstip) from sometable
where timestamp between timestamp
