mysql select in select where code example

Example: select where mysql

SELECT 
    select_list
FROM
    table_name
WHERE
    search_condition;