title: How to get the full row in Database according to one column
body: <p>I am working in PostGres and i have a row let's say the one below:</p>
  
  <pre><code>CustomerID  CustomerName        ContactName     Address         City    PostalCode  Country
    1        Alfreds Futterkiste   Maria Anders   Obere Str. 57   Berlin  12209       Germany
    2         Ana Trujillo         Emparedados    Borlo 2222      México  05021       Mexico
  </code></pre>
  
  <p>Now i have to get the entire row which contains City as <code>México</code> ? </p>
  
  <p>If it was Row Number basis it was like this (very easy) :</p>
  
  <pre><code>select * from Customers limit RowNumber-1, 1
  </code></pre>
  
  <p>I know how to get the row on the number of row basis but i don't know how to get the row on the data of column basis (Mexico in my case) ?</p>
  
  <p><strong>Note</strong> please note that i have to store each column in a List of Class, I mean something like this :</p>
  
  <pre><code>List&lt;Coustomer&gt; cstmr = new List&lt;Coustomer&gt;() ;
  </code></pre>
  
  <p>// and do somethign like this</p>
  
  <pre><code>foreach(var column in cstmr)
  column.CustomerName=Ana Trujillo; // in Mexico's case
  column.Country=Mexico;
  </code></pre>