On Mon, Feb 2, 2009 at 13:43, Martin Gainty <[email protected]> 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>
[email protected] || [email protected]
http://www.parasane.net/ || http://www.pilotpig.net/
Unadvertised dedicated server deals, too low to print - email me to find out!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
