how to select all attributes from a row if there is a certain string in it MySQL
SELECT column1, column2,... FROM table_name WHERE first_name = 'John' AND sales_in_year <= 50
mysql SELECT
SELECT `nachname` , `vorname` FROM testadressen WHERE vorname = 'Fischer'
Source: www.php-kurs.com