The SELECT statement in MySQL is used to retrieve data from one or more tables.
SELECT column1, column2, ... FROM table_name WHERE condition;
column1, column2, ...: The columns you want to retrieve from the table. We can use an asterisk (*) to select all columns.
table_name: The name of the table from which we can retrieve data.
WHERE condition: An optional clause that allows us to filter the results based on a specified condition
SELECT * FROM products;
SELECT product_name, product_price, category FROM products;
SELECT * FROM products WHERE category = 'GAMES';