title: PDO MySQL "not in()" not working
body: <p>I have a query that returns related video titles from a given video so same genre, country, date published etc.</p>
  
  <p>I want to exclude certain <code>video_names</code> using <code>not in ()</code> function. The problem is that the query returns the videos I want to exclude and they are sorted first in the array also. Why is this happening?</p>
  
  <pre><code>public function interval($month, $not, $limit) {
      $this-&gt;not = array_unique($not);
      $i = implode(',', $this-&gt;not);
  
      echo $i;//prints: onajr,babyjem,posh
  
      $query = '
          select title, artists, published, views, video_name, yt_id, duration, play_start, genre, country from videos
          where
          published BETWEEN :published - INTERVAL :month MONTH AND :published + INTERVAL :month MONTH
          and MATCH(country) AGAINST(:country IN boolean mode)
          and MATCH(genre) AGAINST(:genre IN boolean mode)
          and
          video_name not in (" :i ")
          ORDER BY RAND() limit :limit
      ';
  
      $run_query = $this-&gt;pdo-&gt;prepare($query);
  
      $run_query-&gt;bindValue(':published', $this-&gt;published);
      $run_query-&gt;bindValue(':country', '+' . $this-&gt;data-&gt;country);
      $run_query-&gt;bindValue(':genre', '+' . $this-&gt;data-&gt;genre);
      $run_query-&gt;bindValue(':limit', $limit, PDO::PARAM_INT);
      $run_query-&gt;bindValue(':month', $month, PDO::PARAM_INT);
      $run_query-&gt;bindValue(':i', $i);
  
      $run_query-&gt;execute();
      $data =  $run_query-&gt;fetchAll(PDO::FETCH_ASSOC);
  
      print_r($data);
      //contains all three of them onajr,babyjem,posh
  }
  </code></pre>