title: Select only unique row/record in mysql
body: <p>I would like to see how I can get only unique row/records that have a unique city and not care if it's capital so for example: </p>
  
  <pre><code>Akron
  akron
  aKRON
  </code></pre>
  
  <p>would only return one record.</p>
  
  <p>I tired something like this but it doesn't work</p>
  
  <pre><code>"SELECT DISTINCT(city) AS city,state_prefix,lattitude,longitude  FROM zip_code WHERE city LIKE '$queryString%' LIMIT 10"
  </code></pre>
  
  <p>Thank you...</p>