title: Why does a MySQL not recognize a table value?
body: <p>Friends</p>
  
  <p>For some reason, a MySQL query refuses to recognize a particular value in a table.</p>
  
  <p>The table contains columns </p>
  
  <pre><code>"idLookUp", "LUgroup", "LUvalue" 
  212 adispo AdmICU_Interv
  213 adispo AdmICU_noInterv
  
  SELECT * FROM LookUp WHERE LUvalue = "AdmICU_Interv";
  </code></pre>
  
  <p>returns no records!</p>
  
  <pre><code>SELECT * FROM LookUp WHERE LUvalue = "AdmICU_noInterv";
  </code></pre>
  
  <p>returns the proper record (#212). </p>
  
  <pre><code>SELECT * FROM LookUp WHERE idLookUp = 212
  </code></pre>
  
  <p>returns the proper record</p>
  
  <p>The string AdmICU_Interv doesn't figure anywhere else and is not a reserved phrase (from what I can tell). I'm sure I'm missing something stupid here, but I can't figure out what is causing this behavior. </p>
  
  <p>I'd appreciate any hints. Thx!</p>
  
  <p>jon</p>