On Mon, Feb 2, 2009 at 13:43, Martin Gainty <mgainty@stripped> wrote:
> select ADDRESS FROM FUBAR_TABLE WHERE MOD(TO_
> NUMBER(SUBSTR(ADDRESS,1,instr(ADDRESS,' ',1))),2) =0;
That hit the nail right on the head. That was the same thing I
was going to suggest, Martin. I think people tend to forget that
MySQL has the ability to handle a lot of stuff inside its own engine.
The only problem is the potential performance degradation --- if it's
an issue, translating that to PHP (which is the language in which
Jason is doing his code) isn't a problem.
In any case, your answer is the one I would consider correct for
the OP's question.
</Daniel P. Brown>
daniel.brown@stripped || danbrown@stripped
http://www.parasane.net/ || http://www.pilotpig.net/
Unadvertised dedicated server deals, too low to print - email me to find out!