MySQL WHERE - Definisanje Kriterijuma za Izvestaj u MySQL Tabeli

Sta ima u tabeli "kucni" trenutno:

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

mysql>

Kada hocemo definisati "strizoji" kriterijum koristicemo WHERE SQL komandu. Recimo da nam trebaju samo podaci za Zorana:

SELECT * FROM kucni WHERE ime='Zoran'

mysql> SELECT * FROM kucni WHERE ime='Zoran';
+----+-------+---------+---------+
| id | ime   | prezime | telefon |
+----+-------+---------+---------+
|  3 | Zoran | Zorisic |  999555 |
+----+-------+---------+---------+
1 row in set (0.05 sec)

mysql>

Odlicno. Mogli ste jos i da suzite kriterijum na prezime:

mysql> SELECT * FROM kucni WHERE ime='Zoran' AND prezime='Zorisic';
+----+-------+---------+---------+
| id | ime   | prezime | telefon |
+----+-------+---------+---------+
|  3 | Zoran | Zorisic |  999555 |
+----+-------+---------+---------+
1 row in set (0.00 sec)

mysql>

Napomena: U prethodnoj WHERE komandi spomenuli smo i AND dodatak. O tome vise u sledecim lekcijama.