How to execute a subquery in MySQL?

One way to execute a subquery in MySQL is by including the subquery statement within the main query statement. Here is a simple example:

SELECT column1, column2
FROM table1
WHERE column1 = (SELECT column1 FROM table2 WHERE column2 = 'value');

In this example, the subquery statement is (SELECT column1 FROM table2 WHERE column2 = ‘value’), which will return a value to be compared with the conditions in the main query statement. A subquery can be used in the main query to retrieve the necessary data based on actual requirements.