title: Room delete multiple rows by WHERE IN clause not working
body: <p>I want to delete multiple rows by their IDs in Android Room by <code>DELETE FROM...WHERE...IN (...)</code> clause. Below is the code:</p>
  
  <p>ItemDao</p>
  
  <pre><code>@Dao
  interface ItemDao {
      @Query("DELETE FROM Item WHERE id IN (:ids)")
      fun deleteItemByIds(ids: String)
  }
  </code></pre>
  
  <p>ItemViewModel</p>
  
  <pre><code>class ItemViewModel(application: Application) : AndroidViewModel(application) {
      fun deleteByIds(ids: String) {
          mScope.launch(Dispatchers.IO) {
              mItemDao.deleteItemByIds(ids)
          }
      }
  }
  </code></pre>
  
  <p>ItemActivity</p>
  
  <pre><code>fun onDelete(){
      // these are not real IDs, just for demo
      val itemIdList = arrayListOf&lt;Long&gt;(1, 2, 3)
      val ids = itemIdList.toString().drop(1).dropLast(1) // ids = "1, 2, 3"
      itemViewModel.deleteByIds(ids)
  }
  </code></pre>
  
  <p>When there's only one ID, the code works. But when there are multiple IDs, it doesn't. So what happened here? Thanks for your help.</p>