title: Calling a user defined stored procedure from select statement mysql
body: <p>I am trying to call a user defined stored procedure from a select statement and its giving me an error. However when I call a system procedure it works just fine. Is there a way to call a user defined procedure from a select statement. This is for mysql</p>
  
  <pre><code>SELECT ID, email FROM user PROCEDURE simpleproc();
  </code></pre>
  
  <p>give me an error ERROR 1106 (42000): Unknown procedure 'simpleproc'</p>
  
  <pre><code>mysql&gt; call simpleproc();
  </code></pre>
  
  <p>Query OK, 0 rows affected (0.21 sec)</p>
  
  <p>where as </p>
  
  <pre><code>SELECT ID, email FROM user PROCEDURE ANALYSE();
  </code></pre>
  
  <p>works</p>