title: MYSQL and PHP fewer API calls
body: <p>Hello i have a api query</p>
  
  <pre><code>select id, name, info1, info2 from Account
  </code></pre>
  
  <p>what i want to know ... is there a way to get all the unique names without having to requery </p>
  
  <pre><code>select distinct name from account
  </code></pre>
  
  <p>im trying to use as little of the api calls as possible?</p>
  
  <p>For example, table named account is as follows</p>
  
  <pre><code>name    number
  charles 1
  mary    2
  charles 3
  mary    4
  </code></pre>
  
  <p>im trying to </p>
  
  <pre><code>select name,number from account
  </code></pre>
  
  <p>is there a way to</p>
  
  <pre><code>select name where name=charles from account
  </code></pre>
  
  <p>without having to requery the api?</p>