SELECT * FROM tabulka
 SELECT * FROM databáze.tabulka
 SELECT sloupec1, sloupec 2, ... FROM tabulka 1, tabulka 2, ...
 SELECT sloupec1, sloupec 2 AS název, ... FROM tabulka 
 SELECT ... FROM ... WHERE podmínka
 SELECT ... FROM ... WHERE podmínka GROUP BY pole
 SELECT ... FROM ... WHERE podmínka GROUP BY pole HAVING podmínka2
 SELECT ... FROM ... WHERE podmínka ORDER BY pole1, pole2
 SELECT ... FROM ... WHERE podmínka ORDER BY pole1, pole2 DESC / ASC
 SELECT ... FROM ... WHERE podmínka LIMIT 10
 SELECT DISTINCT pole1 FROM ...
 SELECT DISTINCT pole1, pole2 FROM ...


 podmínka1 AND podmínka2
 podmínka1 OR podmínka2
 
 operátory
 >   <   <>   !=   >=   <=   
` 
 
 pole = hodnota
 hodnota <> hodnota           
 hodnota != hodnota            
 pole LIKE 'hodnota _ %'
 pole IS NULL
 pole IS NOT NULL
 pole IN (pole1, hodnota2)
 pole1 NOT IN (hodnota1, hodnota2)


 SELECT ... FROM ... WHERE podmínka REGEXP hodnota


 t … tabulka
 SELECT ... FROM t1 JOIN t2 ON t1.id1 = t2.id2 WHERE podmínka
 SELECT ... FROM t1 LEFT JOIN t2 ON t1.id1 = t2.id2 WHERE podmínka
 SELECT ... FROM t1 JOIN (t2 JOIN t3 ON ...) ON ...
 SELECT ... FROM t1 JOIN t2 USING(id) WHERE podmínka