title: How can I select data from mySQL table from rows that are not empty?
body: <p>I want to select data from my table <code>people</code> (MySQL) but only where friend is not empty:</p>
  
  <pre><code>$sql = "SELECT  *  FROM people WHERE friend = '$friend' ORDER BY id ASC AND WHERE friend IS NOT NULL;" ;
  </code></pre>
  
  <p>I tried to write it like this, but it is not working. In this case it is selecting nothing.</p>