MySQL BETWEEN Tutorial - Opsezi vrednosti

Kada su nam potrebni izvestaji na osnovu nekih poznatih opsega koristicemo BETWEEN:

Recimo da hocemo samo redove od 3 do 5:

mysql> SELECT * FROM kucni
    -> WHERE id BETWEEN 3 AND 5;
+----+---------+-------------+---------+
| id | ime     | prezime     | telefon |
+----+---------+-------------+---------+
|  3 | Zoran   | Zorisic     |  999555 |
|  4 | Marko   | Markovic    |  787878 |
|  5 | Predrag | Predragovic |  333888 |
+----+---------+-------------+---------+
3 rows in set (0.08 sec)

mysql>