Is there a way to represent infinity in mysql? I've got a range field in my GUI, which is "> x"...
if the user chooses this field, in the DB, I store it as: id | from | to | other 2 | x | infinity | etc... this is because there are situations of "< x" and "between x AND y", so from and to is the easiest way to store it... I could make infinity default to 100,000,000 or some other number I know will never be reached, but it seems less elegant a solution... thanx, Scott. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
