title: Select rows from column with same value
body: <p>I have a table of book authors, and am trying to get a query result of books by a certain author. </p>
  
  <p>Something like</p>
  
  <p><code>SELECT * FROM mytable WHERE authors = Carl Sagan</code> </p>
  
  <p>I need all of the columns for each row that matches. </p>
  
  <p>Any help would be appreciated, I'm new to SQL. </p>
  
  <p>Thanks!</p>