What is the command for querying a MySQL database?

When querying a MySQL database, data can be retrieved using the SELECT statement. Here is a more detailed example:

Retrieve data from a single column.

SELECT column_name FROM table_name;

Retrieve data from multiple columns.

SELECT column1, column2 FROM table_name;

Retrieve data from all columns.

SELECT * FROM table_name;

Search for data with specific conditions.

SELECT * FROM table_name WHERE condition;

result sorting

SELECT * FROM table_name ORDER BY column_name ASC|DESC;

These are some common MySQL query examples. You can further adjust them according to your own needs and database structure.