The SELECT statement returns results from a table. With a WHERE clause only some rows are returned. In this example shows the year that Athens hosted the Olympic games.

SELECT yr, city FROM games WHERE city='Athens'
DROP TABLE games; CREATE TABLE games(yr INT, city VARCHAR(20)); INSERT INTO games(city,yr) VALUES ('Sydney',2000); INSERT INTO games(city,yr) VALUES ('Athens',2004); INSERT INTO games(city,yr) VALUES ('Beijing',2008); INSERT INTO games(city,yr) VALUES ('London',2012);

SELECT yr, city FROM games
 WHERE city='Athens'