title: Prompt user to input a variable in MySQL
body: <p>At school, I believe I work with Oracle SQL Developer when writing SQL. And in this I can type:</p>
  
  <pre><code>SELECT Book_Title, Auth_ID
  FROM book
  WHERE Auth_ID = '&amp;Enter ID';
  </code></pre>
  
  <p>This will then display a little message box where the user can enter an ID number to see all the books written by an author with that ID number.</p>
  
  <p>I want to know if there is a way to do this in MySQL. I have looked and the nearest thing I can find is setting a variable before hand, which is not quite what I'm looking for:</p>
  
  <pre><code>SET @EnterID := 2;
  select Book_Title, Auth_ID
  from book
  where Auth_ID = @EnterID;
  </code></pre>
  
  <p>The above statement in MySQL <em>will</em> return all the books with author ID of 2, but only because I set it to that previously. I want the user to be able to enter the variable.</p>
  
  <p>Thanks.</p>