title: Select Null statement, Is it possible?
body: <p>I am creating a Java application which uses the log in mechanism, to test this, I am using a </p>
  
  <blockquote>
    <p>SELECT loginname FROM TABLE WHERE password="abc".</p>
  </blockquote>
  
  <p>This is actually selecting a tuple from the table, I pass this into the result statement rs and then test for rs.next() and if it's true, then the entered username and password is correct.</p>
  
  <p>I just had a question, is it possible to run a SELECT statement which returns no data but still marks the tuple? i.e. The query should return a set of rows equivalent to the number of matches, but they should all be null. I do not want to use COUNT and other functions. I just wanted to know, whether this is technically possible?</p>
  
  <p>e.g. </p>
  
  <blockquote>
    <p>SELECT NONE FROM TABLE WHERE password="abc".</p>
  </blockquote>
  
  <p><strong>Edit:</strong> I am using MySQL</p>