Re: function to limit value of integer

2011-02-11 Thread Riebold, Philip
avis >>> >>> -Original Message- >>> From: Richard Reina [mailto:gatorre...@gmail.com] >>> Sent: Thursday, February 10, 2011 3:07 PM >>> To: mysql@lists.mysql.com >>> Subject: function to limit value of integer >>> >>&g

Re: function to limit value of integer

2011-02-11 Thread Johan De Meersman
ng > > system you want to use. > > > > -Travis > > > > -Original Message- > > From: Richard Reina [mailto:gatorre...@gmail.com] > > Sent: Thursday, February 10, 2011 3:07 PM > > To: mysql@lists.mysql.com > > Subject: function to limit valu

Re: function to limit value of integer

2011-02-11 Thread Richard Reina
gt; -Travis > > -Original Message- > From: Richard Reina [mailto:gatorre...@gmail.com] > Sent: Thursday, February 10, 2011 3:07 PM > To: mysql@lists.mysql.com > Subject: function to limit value of integer > > Is there a function that can limit the value of an integer i

RE: function to limit value of integer

2011-02-10 Thread Travis Ard
l.com] Sent: Thursday, February 10, 2011 3:07 PM To: mysql@lists.mysql.com Subject: function to limit value of integer Is there a function that can limit the value of an integer in a MySQL query? I am trying to write a query that scores someones experience. However, number of jobs can b

function to limit value of integer

2011-02-10 Thread Richard Reina
Is there a function that can limit the value of an integer in a MySQL query? I am trying to write a query that scores someones experience. However, number of jobs can become overweighted in the the query below. If someone has done 10 jobs vs. 1 that's a big difference in experience. But someone w