title: Select Column A or B based on a matching value
body: <p>I need to extract first part of the string and store it in a variable.</p>
  
  <pre><code>final String[] split = InputValue.split("_", 2);
  final String extractedValue = split[0];
  </code></pre>
  
  <p>Now I need to do something Like this:
  I need to check if the extractedValue is column Emp_Id or Emp_Name</p>
  
  <pre><code>"SELECT Count(*)as count,Emp_Name,Emp_Id FROM Employee WHERE extractedValue=? IN(Emp_Id,Emp_Name)";
  
  preparedStatement.setString(1, extractedValue);
  </code></pre>
  
  <p>I am getting a error No such column in Employee table.</p>
  
  <p>How to check for a matching column  value here?
  Any help is appreciated. </p>