SELECT * FROM test WHERE bpm < ( 100 * 1.08 ) AND bpm > (100*.92)
Stembridge, Michael wrote:
Hello,
I have a music database containing song BPM (Beats Per Minute) data values
stored as FLOAT. I need to pull a range of BPM values based on a
user-supplied integer. The range should pull all records which are 8%
higher and lower than the given integer.
I tried this query for starters:
SELECT
*
FROM
test
HAVING
(
bpm < SUM(100 * 1.08)
) OR (
bpm > SUM(100 * .92)
)
No errors appeared however only one row returned (with bpm value 55.03).
There are approximately 100 records that have a bpm value between 92.00 and
108.00 in the "test" database.
Am I overlooking something obvious?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
