Re: MOD

MOD is the remainder after division.

MOD(10, 3) = 1
MOD(11, 3) = 2
MOD(12, 3) = 0
MOD(13, 3) = 1

etc.

Tyler Wood wrote:
>
> Hello,
> I'm updating an existing postgres database, and using
> perl with dbi to
> access it.
>
> Everything works fine,
> I'm just not sure what this MOD command means.
> Not asking you to figure it out in this context,
> but just what does MOD do?
>
> $sqh = $dbh->prepare("select
> name,namelink,address,city,state,zip,email
> from company where MOD(nextscreen,2)=1 order
> by $sort_selection;");
> $sqh->execute();
>
> thank you,
>
> Tyler Wood
> twood(at)uwm(dot)edu
>
> __________________________________________________
> Do You Yahoo!?
> Get Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/