|
Basic SELECT query in MySQL |
|
-
# fetch field1 and field2 from all rows in myTable
-
SELECT field1, field2 FROM myTable;
-
-
# only rows where field1 is greater than 10
-
SELECT field1, field2 FROM myTable WHERE field1 > 10;
-
-
# select field1 and the total number of all unique field1s from myTable
-
SELECT field1, count(field1) AS total FROM myTable GROUP BY field1;
-
-
# those with a count(field1) equaling 5
-
SELECT field1, count(field1) AS total FROM myTable GROUP BY field1 HAVING total = 5;
|
