title: MYSQL - Not getting same result with In select as In with numbers
body: <p>If I run a query like so:</p>
  
  <pre><code>SELECT DISTINCT fileName
  FROM files
  WHERE fileID IN (2,3,4,5)
  </code></pre>
  
  <p>It provides result in 4 rows:</p>
  
  <blockquote>
    <p>file2</p>
    
    <p>file3</p>
    
    <p>file4</p>
    
    <p>file5</p>
  </blockquote>
  
  <p>And, the following query provides fileid</p>
  
  <pre><code>SELECT fileID
  FROM folders
  WHERE folderID = 61 
  </code></pre>
  
  <blockquote>
    <p>Result is: 2,3,4,5</p>
  </blockquote>
  
  <p>Can somebody help me find out why I am not getting the same result as 1st query provides?</p>
  
  <pre><code>SELECT DISTINCT fileName
  FROM files
  WHERE fileID IN (
                      SELECT fileID
                      FROM folders
                      WHERE folderID = 61
                  )
  </code></pre>
  
  <blockquote>
    <p>Result is: file2</p>
  </blockquote>
  
  <p>Screenshots: <a href="https://imgur.com/a/iY6pc" rel="nofollow noreferrer">https://imgur.com/a/iY6pc</a></p>
  
  <p>Thank you in Advance! </p>