Function for exact range

[eluser]PhilTem[/eluser]
How do you want to put it into MySQL? Make the query take care of this check like select only rows if some column's value is within that range?

Have a look at http://dev.mysql.com/doc/refman/5.0/en/i...ement.html and http://www.java2s.com/Code/SQL/Flow-Cont...clause.htm for an example.

Quick and dirty example:

Code:

SELECT name AS Name, category AS Category,
    IF( winter > 500, "Sells", "Slow") AS Trend
    FROM sales;