title: Can MySQL check that file exists?
body: <p>I have a table that holds relative paths to real files on HDD. for example: </p>
  
  <pre><code>SELECT * FROM images --&gt;
  id | path
  1  | /files/1.jpg
  2  | /files/2.jpg
  </code></pre>
  
  <p>Can I create a query to select all records pointing to non-existent files? I need to check it by MySql server exactly, without using an iteration in PHP-client.</p>