Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

[Ronaldo31]

Daca am o tabela: table cu urmatoarele inregistrari:

+------+-------+
| id | test |
+------+-------+
| 1 | 5 |
+------+-------+
| 2 | 6 |
+------+-------+
| 3 | 6 |
+------+-------+
| 4 | 7 |
+------+-------+
| 5 | 8 |
+------+-------+
| 6 | 9 |
+------+-------+
| 7 | 6 |
+------+-------+
| 8 | 10 |
+------+-------+
| 9 | 7 |
+------+-------+

Cum pot face sa numar cate inregistrari am in campul TEST cu valorila 5, 6 si 7?

Teoretic ar fi:

SELECT COUNT(*) AS nr FROM table WHERE test = 5 AND test = 6 AND test = 7;

numai ca nu se poate pune de mai multe ori acelasi camp.

Cum as putea face?

Multumesc!!

[whooper]

incearca cu "sau"

SELECT COUNT(*) AS nr FROM table WHERE test = 5 OR test = 6 OR test = 7;

[PHPRomania Bot]