title: mysql query in clause at playframework
body: <p>in below two sql query <code>sql1</code> not selecting any row, and <code>sql2</code> selecting only 1 for <code>111@k2.com</code></p>
  
  <pre><code> var ids="'111@k2.com','222@k2.com','333@k2.com','444@k2.com','555@k2.com','666@k2.com'"
  
      val sql1 = SQL("SELECT id,point,privacy FROM `pointTable` WHERE state=1 and  id in ({users})").on("users" -&gt; ids)
      sql1().map { row =&gt;
        val point = if (row[Boolean]("privacy")) { row[Double]("point").toString } else { "0" }
        println(write(Map("id" -&gt; row[String]("id"), "point" -&gt; point)))
      }
  
      val sql2 = SQL("SELECT id,point,privacy FROM `pointTable` WHERE state=1 and  id in (" + ids + ")")
      sql2().map { row =&gt;
        val point = if (row[Boolean]("privacy")) { row[Double]("point").toString } else { "0" }
        println(write(Map("id" -&gt; row[String]("id"), "point" -&gt; point)))
      }
  </code></pre>
  
  <p>in phpmyadmin when i run this query manualy it returns 6 rows then why not working perfectly here.
  i am using play framework 2.2 with scala 2.1</p>