MySQL Select

MySQL Select

MySQL select syntax and examples.

MySQL Select syntax

SELECT * FROM table_name;

SELECT col1, col2 FROM table_name;

SELECT col1, col2 FROM table_name WHERE condition;

Table test

IDNAME
1abc
2def
3ghi
4jkl

Select example

SELECT * FROM test WHERE id=1;

Query Result

IDNAME
1abc