Python MySQL

MySQL Where

WHERE clause

MySQL Where

You can filter records by using the "WHERE" statement.

Select with WHERE

mycursor.execute("SELECT * FROM customers WHERE address = 'Park Lane 38'")
myresult = mycursor.fetchall()
for x in myresult:
    print(x)