Asking for everything "up to" a value [MySQL]

If I would like to:

S开发者_如何学PythonELECT * FROM `Students` 

...from age 0 to 20, how would I do this?

---

select * from students where age between 0 and 20

---

SELECT *
FROM   Students
WHERE  Age >= 0 AND Age <= 20

MySQL has many operators from which you can choose.

---

You should be careful with "between". Different databased treat it differently. For instance in...

age between 0 and 20

... some DBs will gathers people with ages of 0-20 but some will gather people with ages 1-19 and so on.