title: How to pass dynamic parameters to a MySQL view
body: <p>I have created the following view in MySQL:</p>
  <pre><code>CREATE VIEW MYVIEW AS (
  SELECT A.FNAME
       , A.LNAME
       , B.EMAIL
  FROM EMPLOYEE A, EMPEMAIL B
  WHERE A.EID = :empId
    AND A.EID = B.EID
  AND B.EMAILTYP = :emailType)
  </code></pre>
  <p>I have to make <code>empId</code> and <code>emailType</code> dynamic i.e. get the result for the desired values of <code>empId</code> and <code>emailType</code> at runtime.</p>
  <p>What changes should be made in the code?</p>
  <p>Thanks in advance.</p>