title: Something analogous to a symlink in MySQL?
body: <p>Would it be possible to store a "link" to another record inside a record? For example:</p>
  
  <pre><code>table USERS
  id    name    link
  -------------------------------------------------------
  1     user1   [link to record with id=4 in table info]
  </code></pre>
  
  <p>So, in PHP, I could do something like this:</p>
  
  <pre><code>// connect to the database etc....
  $query          = "select * from users where id=1";
  $result         = mysql_query($query);
  $another_result = mysql_result($result, 0, 'link');
  </code></pre>
  
  <p>So that <code>$another_result</code> stores the result of another query, in the same raw format as if it was called using <code>mysql_query()</code>.</p>
  
  <p>Is this possible?</p>