SELECT * WHERE row "is between 9 and 10"?

[DaveLinger]

I'm working on script which will check the score of each game review in a database, and display any games with a score between 9 and 10. (This may include "9", "9.2", "9.75", "10")

How would I work that into an SQL query?

Thanks!

[bltesar]

SELECT * FROM games WHERE score>8 and score<11

[Corona4456]

Well assuming that 10 is the highest you can get ... you can do:
SELECT * FROM `tablename` WHERE `score` >= '9'

Or you you can do:
SELECT * FROM `tablename` WHERE `score` >= '9' AND `score` <= '10'

[bltesar]

Sorry, I didn't read the question as carefully as I should have.  Yes, WHERE >=9 AND <=10 is the correct clause.

[DaveLinger]

Thanks guys

[ToonMariner]

you could even use the thing designed for it!!!

SELECT * FROM `tablename` WHERE `score` BETWEEN 8 AND 11