title: fetch data from mysql table using php ignoring some values?
body: <p>I have a table which have a column with name <code>domain_name</code>. in <code>domain_name</code> column, different values stores like <code>google.com</code>, <code>facebook.com</code>, <code>twitter.com</code> etc.  I try this which is working.</p>
  
  <p><code>$query= 'Select * from accountdb WHERE domain_name="twitter.com" order by domain_name ASC';</code></p>
  
  <p>But I want to pick that rows which have the values <code>facebook.com</code>, <code>twitter.com</code> in one query. I try this to achieve but not working.</p>
  
  <p><code>$query= 'Select * from accountdb WHERE domain_name="twitter.com" and domain_name="facebook.com" order by domain_name ASC';</code></p>
  
  <p>Alterring quotes</p>
  
  <p><code>$query= "Select * from accountdb WHERE domain_name='twitter.com' and name='facebook.com' order by domain_name ASC";</code></p>
  
  <p>Any hint would be appreciated.</p>