title: MySQLi: SELECT all users that are NOT in the user logged in friend array
body: <p>I'm trying to randomly select users from the dB that are not recognized as afriend in the current users (userLoggedIn) friend array.  I have users in the friend array tabled like this: </p>
  
  <pre><code>,edith_copecky,eddie_sasnchez,jay_beagle,red_one, 
  </code></pre>
  
  <p>When I make calls to extract only those that are friends I use the following:</p>
  
  <pre><code>$query = mysqli_query($con,"SELECT * FROM users WHERE friend_array LIKE '$username,%' OR friend_array LIKE '%,$username,%' OR friend_array LIKE '%,$username' LIMIT 0,8");
  </code></pre>
  
  <p>but now I'm wanting to do the opposite and have them display randomly but am unsure how.  </p>
  
  <pre><code>$not_friend_query = mysqli_query($con,"SELECT * FROM users WHERE username ......???? ORDER BY RAND() LIMIT 0,5");
  </code></pre>
  
  <p>I'm fairly new to this so please go easy :)  I'm just not sure how to filter away  those members whom are already friends with the userLoggedIn, from the query result. </p>