title: MySQL, create a simple function
body: <p>I want to create a simple MySQL function, I have this MySQL procedure:</p>
  
  <pre><code>CREATE PROCEDURE getUser(gU INT)
     SELECT * FROM Company
     WHERE id_number = gU;
  
  CALL getUser(2);
  </code></pre>
  
  <p>I need some help making this into a MySQL function.  What are the pros and cons of using a function over a procedure?</p>