title: Mysql search query two columns
body: <p>I'm bulding a search function for my web site and wish to search by two columns: title and author.</p>
  
  <p>Query: </p>
  
  <pre><code>SELECT title, bookID, publisher, pubDate, book_image, books.authorID, authors.author FROM books, authors WHERE books.authorID = authors.authorID 
              AND title LIKE '$queryString%' OR author LIKE '$queryString%'LIMIT 5
  </code></pre>
  
  <p>When I search by title this works fine, but when I search by author I get a list of all books with the searched for author as author. Obviously this is incorrect.</p>
  
  <p>How can I fix this query to successfully search for either title or author?</p>