title: MySql multiple times Where in Condition if possible
body: <p>i am Performing the <code>MySQL query with Where In conditions</code>.</p>
  
  <p>Here is my Query.</p>
  
  <p>The query should be:</p>
  
  <pre><code>SELECT * FROM users WHERE id IN (44,44,33,44,33,0);
  </code></pre>
  
  <p><strong>Query showing my correct result, no problem at all, 
  but what i want to do is Can we Divide all the id with the individual conditions ?</strong></p>
  
  <p>Or can a query has multiple <code>Where In</code> for a <code>single column</code>? 
  like</p>
  
  <p><strong>SELECT * FROM users WHERE id IN (44)
  AND id IN (45)
  AND id IN (46);</strong></p>
  
  <p>like this. </p>
  
  <p><strong>Is that possible ? ?</strong></p>
  
  <p>My query code for performing the query, its in Laravel.</p>
  
  <pre><code>$films = Film::with('genre')-&gt;with('languages')-&gt;with('likes')-&gt;with('comments')-&gt;with('likedBy');
  
          if(Input::get('sort')){
              $sort = Input::get('sort');
              switch ($sort){
                  case 'old_new':
                      $films = $films-&gt;orderBy('created_at', 'asc');
                      break;
                  case 'new_old':
                      $films = $films-&gt;orderBy('created_at', 'desc');
                      break;
                  case 'views':
  //                    $films = DB::table('films')
  //                        -&gt;leftJoin('film_views', 'films.id', '=', 'film_views.film_id')
  //                        -&gt;select(DB::raw('films.*, count(film_views.film_id) as views'))
  //                        -&gt;groupBy('films.id')
  //                        -&gt;orderBy('views' , 'desc')
  //                        ;
  
                      $films = $films
                          -&gt;leftJoin('film_views', 'films.id', '=', 'film_views.film_id')
                          -&gt;select(DB::raw('films.*, count(film_views.film_id) as views'))
                          //-&gt;whereBetween('created_at', [$this-&gt;first_day_of_search, $this-&gt;final_day_of_search])
                          -&gt;groupBy('films.id')
                          -&gt;orderBy('views' , 'desc')
                      ;
  
                      break;
                  case 'likes':
                      $films = $films
                          -&gt;leftJoin('film_likes', 'films.id', '=', 'film_likes.film_id')
                          -&gt;select(DB::raw('films.*, count(film_likes.film_id) as likes'))
                          -&gt;groupBy('films.id')
                          -&gt;orderBy('likes' , 'desc')
                         ;
                      break;
              }
  
  
          }
          if(Input::get('filter')) {
              $jsonFilter = Input::get('filter');
              $filters = json_decode($jsonFilter);
  
              foreach ($filters as $filter =&gt; $value){
                  switch ($filter){
                      case "genre":
                          if($value){
                              $films = $films-&gt;whereHas('genre', function ($query) use($value) {
                                  $query-&gt;whereIn('genre_id', $value);
                              });
                          }
                          break;
                      case "cert":
                         if($value){
                             $films = $films-&gt;whereIn('cert', $value);
                         }
                          break;
                      case "country":
                          if($value){
                              $films = $films-&gt;whereIn('country', $value);
                          }
                          break;
                      case "lang":
                         if($value){
                             $films = $films-&gt;whereHas('languages', function ($query) use($value) {
                                 $query-&gt;whereIn('language_id', $value);
                             });
                         }
                          break;
                  }
              }
  
  
          }
  
  
  
          $films = $films-&gt;paginate(5);
  
          return parent::api_response($films-&gt;toArray(), true, ['return' =&gt; 'all films'], 200);
  </code></pre>