title: Java MySQL How to select rows within a ResultSet?
body: <p>I have a very basic MySQL Database. This is the query I used to create it:</p>
  
  <pre><code>CREATE TABLE SC_Users(
  ID int(11) NOT NULL AUTO_INCREMENT, 
  PRIMARY KEY (ID), 
  Username varchar(255) NOT NULL, 
  Class varchar(255) NOT NULL
  )
  </code></pre>
  
  <p>I get a ResultSet by querying my database with this:</p>
  
  <pre><code>SELECT * FROM SC_Users
  </code></pre>
  
  <p>I want to be able to search for a username and then find the corresponding class of that username. How would I do this without using a different query?</p>
  
  <p>I know its possible to find it easily by using:</p>
  
  <pre><code>SELECT * FROM SC_Users WHERE `Username` = Username
  </code></pre>
  
  <p>But I would prefer to use only 1 query if possible to find any value of a user I want.
  Thanks in advance for the help!</p>