title: Display the contents of a VIEW in MySQL
body: <p>This is actually a two part question. </p>
  
  <p><strong>First:</strong> I was wondering if there is a way to display the information in a view I just created. I couldn't find anything online that was similar to the DISPLAY Tables query that could be used for views.</p>
  
  <p>The query to create my view is:</p>
  
  <pre><code>CREATE VIEW View1 AS
  SELECT *
  FROM CustOrder
  WHERE shipToName = 'Jim Bob'
  </code></pre>
  
  <p><strong>Secondly</strong>, once I find out how to display that specific view from above, how do I go about finding the highest "paidPrice" (a column in the CustOrder table)? </p>
  
  <p>Thank you all in advance!</p>