title: Android Room Database like query not working
body: <p>I have added a field to know whether the item is deleted or not by the user and if it is deleted it should not be visible to the user.</p>
  <p>I wrote the following query for it</p>
  <pre><code> @Query(&quot;SELECT * FROM post_info WHERE deleted=0 &amp; postedBy LIKE :search || '%' OR  postName LIKE :search || '%' OR postDes LIKE :search || '%' ORDER BY postid DESC &quot;)
       fun searchFilter(search:String):Flow&lt;List&lt;PostEntity&gt;&gt;
  </code></pre>
  <p>But i am getting all the data and not only WHERE deleted=0 means false but when I search and filter it manually it works fine like</p>
  <pre><code>  viewModel.searchFilter(searchQuery).observe(this) {
  
              it.let {
                  var listOF= mutableListOf&lt;PostEntity&gt;()
                  for(list in it){
                      if(!list.deleted){
                          listOF.add(list)
  
                      }
                  }
                  adapter.setDataList(listOF)}
          }
  </code></pre>
  <p>This works fine but the Query doesn't work.</p>