query = "SELECT * FROM subject
         WHERE teacher LIKE %s"

with conn:
   cursor = conn.cursor()
   cursor.execute(query, ("Ms.%"))
   subjects = cursor.fetchall()
   for s in subjects:
      print(s["Name"])