title: select ... where id = any value. is it possible?
body: <p>look at this table please</p>
  
  <pre><code>table
  |id| |name| |order|
  </code></pre>
  
  <p>i must get the rows, where <code>name = something</code> and  <code>order = somevalue</code> </p>
  
  <p>so i write </p>
  
  <pre><code>select `id` from `table` where `name` = 'something' and `order` = 'somevalue'
  </code></pre>
  
  <p>but depend on php logic, sometimes i need to get all rows, where <code>name = something</code>, independently of <code>order</code> value. i don't want to change the query structure, because in practise there are many number of fields, and possible count of queries will become very big. so i want to <strong>save</strong> the structure of query, and when i need to select just by name, i want to write something like this:</p>
  
  <pre><code>select `id` from `table` where `name` = 'something' and `order` = any value 
  </code></pre>
  
  <p>is it possible?</p>
  
  <p>thanks</p>