MySQL SELECT IN Tutorial

Moze se reci da SELECT IN MySQL komandu koristite kada tacno znate sta trazite.

U nasoj tabeli "kucni", u bazi "prijatelji", imate sledece podatke:

mysql> SELECT * FROM kucni;
+----+---------+-------------+---------+
| id | ime     | prezime     | telefon |
+----+---------+-------------+---------+
|  1 | Petar   | Peric       |  888555 |
|  2 | Milutin | Miric       |  111222 |
|  3 | Zoran   | Zorisic     |  999555 |
|  4 | Marko   | Markovic    |  787878 |
|  5 | Predrag | Predragovic |  333888 |
|  6 | Petar   | Petrovic    |  555555 |
+----+---------+-------------+---------+
6 rows in set (0.00 sec)

mysql>

Recimo da nam trebaju svi podaci za prezimena Peric, Petrovic i Markovic:

mysql> SELECT * FROM kucni
    -> WHERE prezime IN ('Peric', 'Petrovic', 'Markovic');
+----+-------+----------+---------+
| id | ime   | prezime  | telefon |
+----+-------+----------+---------+
|  1 | Petar | Peric    |  888555 |
|  4 | Marko | Markovic |  787878 |
|  6 | Petar | Petrovic |  555555 |
+----+-------+----------+---------+
3 rows in set (0.03 sec)

mysql>