title: MySQL check if file exists on the server
body: <p>I am developing an application using PHP, MySQL. I have a table in my mysql database which has got file names stored in it. I want to trigger 'SELECT' query which will check (from the file names in table) if file exists on the server. If yes, it should return yes, else no. I tried using LOAD_FILE but with no success. Please let me know how can i do this using MySQL's SELECT query.</p>