SELECT * FROM help

+----+-------+-------+
| id | dataA | dataB |
+----+-------+-------+
|  1 |    75 |   100 |
|  2 |   256 |    75 |
+----+-------+-------+

Hey, just wondering how I could selec开发者_JAVA百科t ONLY the data in dataA with id=1 ?? The table is called stats ie: $query = "SELECT * FROM stats WHERE and this is where I am stuck. Any suggestions?

select dataA from stats where id=1;

select dataA from stats 
             where id=1;

Also note that you subject line says to select everything but the question content says to select tuples of dataA where id=1 only.